PLS-00123: program too large (string)
Cause: PL or SQL was designed primarily for robust transaction processing. One consequence of the special-purpose design is that the PL or SQL compiler imposes a limit on block size. The limit depends on the mix of statements in the PL or 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.
Cause: PL or SQL was designed primarily for robust transaction processing. One consequence of the special-purpose design is that the PL or SQL compiler imposes a limit on block size. The limit depends on the mix of statements in the PL or 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.
No comments:
Post a Comment