Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-15103: conflicting or duplicate REPAIR options

1 Answers  


ORA-28576: lost RPC connection to external procedure agent

1 Answers  


ORA-23336: priority group string does not exist

1 Answers  


NNL-00267: Address is string

1 Answers  


ORA-32307: must use FROM ONLY clause when referencing an object table

1 Answers  






ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision

1 Answers  


NZE-28792: PL/SQL operation failure

1 Answers  


ORA-16812: apply service not running on the apply instance recorded by the broker

1 Answers  


RMAN-20504: corruption list not found in recovery catalog

1 Answers  


ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes

1 Answers  


NNO-00072: loading from region database

1 Answers  


PLS-00248: Invalid Library Syntax

1 Answers  






Categories