Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  


ORA-16763: log transport service for some standby database unexpectedly online

1 Answers  


NNL-00509: set|show cache_checkpoint_interval [<seconds>] [<server_list>] : set|show the server's cache checkpoint interval

1 Answers  


O2U-00206: Some characters in a type name were not legal identifier characters

1 Answers  


ORA-01147: SYSTEM tablespace file string is offline

1 Answers  


ORA-06803: TLI Driver: the IPX device file could not be opened

1 Answers  


ORA-30649: missing DIRECTORY keyword

1 Answers  


ORA-29878: warning in the execution of ODCIINDEXTRUNCATE routine

1 Answers  


PLS-00452: Subprogram 'string' violates its associated pragma

1 Answers  


RMAN-00577: PIPE requires that TARGET be specified on the command line

1 Answers  


ORA-29545: badly formed class: string

1 Answers  


ORA-23374: object group "string"."string" already exists

1 Answers  


Categories