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-25504: the system is already in quiesced state

1 Answers  


ORA-13120: invalid face_id [string]

1 Answers  


ORA-14094: invalid ALTER TABLE EXCHANGE PARTITION option

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  


QSM-01610: a lossy join in equivalence, string, between tables, string, not found in query

1 Answers  






TNS-12611: TNS:operation is not portable

1 Answers  


ORA-06033: NETDNT: connect failed, partner rejected connection

1 Answers  


ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.

1 Answers  


ORA-38722: ON or OFF expected.

1 Answers  


ORA-08101: index key does not exist file string: (root string, node string) blocks (string)

1 Answers  


QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed

1 Answers  


TNS-04070: Cannot administer a remote Oracle Connection Manager instance which is not yet started.

1 Answers  


Categories