Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PLS-00123: program too large
docs say:
PLS-00123: program too large
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.
can i calculate or estimate this limit??? Received on Tue Jan 29 2002 - 12:00:45 CST