How to fix the Oracle error ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory?

In this post, you’ll learn more about the Oracle ErrorORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

Reason for the Error ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory

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.

How to fix the Error ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory ?

You can fix this error in Oracle by following the below steps

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.