Database Error Messages

ORA-06505

PL/SQL: variable requires more than 32767 bytes

Cause

A value larger than 32767 bytes was returned where this was not supported.


Action

Reduce the size of the returned value. This can be done by reducing the number of characters returned or (in case of multi-byte character sets) by changing the database or national character set to such that requires fewer bytes for the same return value. Note: changing the character set will impact the execution of all PL/SQL code.