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-19679: RMAN configuration number string is outside valid range of 1 through string

1 Answers  


ORA-07416: slpath: pathname construction failed; lack of output buffer space.

1 Answers  


ORA-32150: Cannot perform operation on a null timestamp

1 Answers  


ORA-39130: Object type string not imported. Base object name conflicts with the master table

1 Answers  


ORA-02351: internal error: string

1 Answers  






ORA-32024: invalid directory specified for audit_file_dest parameter

1 Answers  


NNO-00313: server password length string exceeds maximum of string

1 Answers  


ORA-28546: connection initialization failed, probable Net8 admin error

1 Answers  


ORA-29832: cannot drop or replace an indextype with dependent indexes

1 Answers  


ORA-08467: error converting Oracle number to string

1 Answers  


LFI-01514: ftell() failed in string

1 Answers  


NID-00416: Change of database name failed.

1 Answers  


Categories