Program too large

From: B. Lelangue <lelangue_at_sia.ucl.ac.be>
Date: 1998/03/25
Message-ID: <35192522.2B78@sia.ucl.ac.be>#1/1

Hello to all NewsReaders,

When I want to compile a package body
sqlplus answers "PLS-00123: program too large"

the text for the 00123 is:

---

program too large
 Cause:
PL/SQL was designed primarily for robust transactionprocessing. 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 your PL/SQL block. Blocks that exceed the limit cause this error.

Action:
The best solution is to modularize your program by defining subprograms, which can be stored in an Oracle database.
Another solution is to break your 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.

---

I can follow the suggered actions but is there somewhere one parameter to modify and so increase the block size ?

Thanks for your answers.

Bertrand Lelangue, SIA,
Université catholique de Louvain la Neuve, Belgium. Received on Wed Mar 25 1998 - 00:00:00 CST