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

ORA-07658: slsprom:$QIOW read failure

1 Answers  


TNS-12197: TNS:keyword-value resolution error

1 Answers  


RMAN-06065: The backup operand [string] conflicts with another specified operand.

1 Answers  


DRG-11214: execution of procedure filter stored procedure has failed

1 Answers  


EXP-00035: QUERY parameter valid only for table mode exports

1 Answers  






ORA-09767: osnmfs: bad return code from msg_send.

1 Answers  


RMAN-06558: archived log size of number kb is bigger than available space of number kb

1 Answers  


NID-00395: Reverting database name from string to string

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-27147: post/wait reset failed

1 Answers  


RMAN-06560: WARNING: backup set with key number will be read number times

1 Answers  


ORA-06431: ssaio: Invalid Block number

1 Answers  


Categories