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



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

Answer / guest

Cause: 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: 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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00063: cannot construct domain checkpoint file name

1 Answers  


SQL*Loader-00526: OCI return status: success with info

1 Answers  


IMP-00091: Above error occurred on the following function and object: string. Remaining PL/SQL blocks for this object will be skipped.

1 Answers  


NID-00452: Succesfully changed database ID.

1 Answers  


SQL*Loader-00514: Error getting elapsed time

1 Answers  


ORA-24395: cannot reinitialize non-existent pool

1 Answers  


ORA-13600: error encountered in Advisor string

1 Answers  


ORA-01345: Supplemental log data must be enabled to build into the logstream

1 Answers  


ORA-00201: controlfile version string incompatible with ORACLE version string

1 Answers  


IMG-00525: locale error

1 Answers  


ORA-02214: duplicate BACKUP option specification

1 Answers  


ORA-16164: LGWR network server host detach error

1 Answers  


Categories