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


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

LPX-00004: internal error "~s"

1 Answers  


ORA-24028: cannot create a reciever non-repudiable single consumer queue

1 Answers  


EXP-00010: %s is not a valid username

1 Answers  


ORA-06518: PL/SQL: Probe version string incompatible with version string

1 Answers  


ORA-09291: sksachk: invalid device specified for archive destination

1 Answers  






AUD-00704: invalid input format

1 Answers  


RMAN-06493: only UNTIL TIME clause is allowed when performing a restore from autobackup, found: string

1 Answers  


ORA-28506: parse error in data dictionary translation for string stored in string

1 Answers  


ORA-06927: CMX: T_DATAIN received before all data written

1 Answers  


ORA-28651: Primary index on IOTs can not be marked unusable

1 Answers  


ORA-01230: cannot make read only - file string is offline

1 Answers  


SQL*Loader-00932: Could not truncate table string.

1 Answers  






Categories