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...


PLS-00123: program too large



PLS-00123: program too large..

Answer / guest

Cause: PL/SQL was designed primarily for robust transaction
processing. One consequence of the special-purpose design is
that the PL/SQL compiler imposes a limit on block size. The
limit depends on the mix of statements in the PL/SQL block.
Blocks that exceed the limit cause this error.

Action: The best solution is to modularize the program by
defining subprograms, which can be stored in an Oracle
database. Another solution is to break the program into two
sub-blocks. Have the first block INSERT any data the second
block needs into a temporary database table. Then, have the
second block SELECT the data from the table.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25269: cant specify sognature with get signature option

1 Answers  


ORA-31661: there are no metadata transform values of type VARCHAR2

1 Answers  


PLS-01714: ANSI expects a column name not a literal value here

1 Answers  


ORA-25210: invalid value for RELATIVE_MSGID, no message in queue with that msgid

1 Answers  


ORA-07718: sksafre: error freeing memory

1 Answers  


PLS-00609: the OVERRIDING clause is not valid for SQLJ Object Types

1 Answers  


ORA-01518: CREATE DATABASE must specify more than one log file

1 Answers  


PLS-00907: cannot load library unit string (referenced by string)

1 Answers  


ORA-13184: failed to initialize tessellation package

1 Answers  


ORA-02320: failure in creating storage table for nested table column string

1 Answers  


ORA-25117: MIN/MAX/Block Number expected

1 Answers  


ORA-16582: Could not edit instance specific property.

1 Answers  


Categories