HELP, PLS-00123 Program too Large

From: Larry Jones <lljo_at_chevron.com>
Date: 1997/08/26
Message-ID: <3403333E.4919_at_chevron.com>#1/1


We have a PL/SQL package which is now something like 2700 lines, with some code we just added. We now get the error message PLS-00123 PROGRAM TOO LARGE. The manual says the following

CAUSE: "...the compiler imposes a limit on block size. The limit depends on the mix of statemets in the PL/SQL block."

ACTION: "The best solution is to modularize the program by defining subprograms, which can be stored in an Oracle database."

We tried breaking part of the package (which was one procedure) into a procedure and a function, but that did not work. We still get the same message.

I suppose we can break the package into two packages, but the problem is that the second package needs to access 3 different arrays from the first package, which would be a real pain if we have to break this into two packages.

Our versions are as follows:
SQL*Plus: Release 3.3.2.0.2
Oracle7 Server Release 7.1.6.2.0
PL/SQL Release 2.1.6.2.0

I sure could use some advice on this. This is an important package, which may grow in the future, depending on any new record types for the database.

Thanks in advance.

-- 
**********************
Larry Jones
lljo_at_chevron.com
Received on Tue Aug 26 1997 - 00:00:00 CEST

Original text of this message