RE: pls-00123 - Program too Large

Hi Imma,

This error is concerned with number of Diana nodes (PL/SQL internals) and some other internal restrictions
of PL/SQL machine.
There is no direct relationship between appearance of PLS-00123 and size of the package.
You can find 2 or 3 good notes on Metalink that explain the limitations in detail. And if my memory services me right, unfortunately, the only way to avoid this
problem is to divide your package into smaller parts

Regards,
Ed

>
>
> We have a tool (an own-made pl/sql code generator) whose purpose
> is to generate a PL/SQL Package containing one pls function for
> each Table/View that has been configured in a specific
> repository table.
> Depending on the number of table/view configured the package
> dimension
> grows. Compiling one of those automatically generated packages we
> got the following error PLS-00123 - Program too Large.
> Obviously one of the possible solution to the the problem is to
> modularize, but depending of the fact that the package code
> is automatically
> generated this could not work.
> Could someone give us a more detailed explanation on why this error
> occurs and eventually a possible solution.
> I've read somethings about an existing correlation between Oracle
> Block_size and PL/SQL block size - has anyone more detailed
> information about this?
> Is it possible to determine in a unique way the max
> dimension a pl/sql package can have?
>
> Thanks in advance
> Imma
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shevtsov, Eduard
  INET: EShevtsov_at_flagship.ru

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).