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

PLS-00248: Invalid Library Syntax

1 Answers  


NZE-29114: Cannot import private key.

1 Answers  


ORA-07285: sksaprd: volume size should not be specified for a disk file.

1 Answers  


TNS-12574: TNS:redirection denied

1 Answers  


ORA-19611: backup piece out of order. Expected string but found string

1 Answers  


ORA-27080: too many files open

1 Answers  


RMAN-08520: channel string: scanning archive log string

1 Answers  


ORA-19006: XMLType TYPE storage option not appropriate for storage type

1 Answers  


PCC-02152: Unable to open file string to display or list the source line number

1 Answers  


ORA-31086: insufficient privileges to register global schema "string"

1 Answers  


ORA-29515: exit called from Java code with status string

1 Answers  


ORA-30039: Cannot drop the undo tablespace

1 Answers  


Categories