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

DRG-10015: id exceeds limit(2147483642) of a number

1 Answers  


ORA-22322: error table "string"."string" has incorrect structure

1 Answers  


DRG-11611: URL store: unknown protocol specified in string

1 Answers  


ORA-31180: DOM Type mismatch in invalid PL/SQL DOM handle

1 Answers  


ORA-38748: cannot flashback data file string - file is in use or recovery

1 Answers  






NCR-04023: NCRR: Invalid object descriptor

1 Answers  


ORA-02426: privilege grant failed

1 Answers  


DRG-50607: failed to obtain column info for cid string

1 Answers  


ORA-01919: role 'string' does not exist

1 Answers  


ORA-28591: agent control utility: unable to access parameter file

1 Answers  


ORA-01704: string literal too long

1 Answers  


ORA-04047: object specified is incompatible with the flag specified

1 Answers  


Categories