Re: PLS-00123: program too large

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 29 Jan 2002 19:14:14 +0100
Message-ID: <aipd5u4kcpatvlco0en2m8334eboscccgc@4ax.com>

On Tue, 29 Jan 2002 19:00:45 +0100, "Steffen Ramlow" <s.ramlow_at_gmx.de> wrote:

>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???
>
>

The limit should equal the size of the DIANA object in SYS. The limit used to be 64k.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jan 29 2002 - 12:14:14 CST