Oracle DB Error ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory

The following is the cause of this error message:

A PL/SQL variable was declared with a constraint which required more than 32767 bytes of memory. PL/SQL does not currently support allocations of contiguous memory greater than 32767 bytes.

Action you can take to resolve this issue: Consider reducing the constraint in the variable declaration. If that is not possible, try changing the database or national character set to such, that requires less memory for the same constraint. Note: changing the character set will impact execution of all PL/SQL code.

Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory

Related