| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: pls-00123 - Program too Large
Probably the problem is with the DIANA dependencies of the object that is limited to about 64k. However the compiled version of the object called m-code has been increasing over the releases. Therefore this also could be a problem the chances here are less than the DIANA thing.
Exactly look for the notes 99882.1 and 62603.1.
Regards.
--- "Shevtsov, Eduard" <EShevtsov_at_flagship.ru> wrote:
> 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
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: ctrassens_at_yahoo.com 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).Received on Mon Jul 16 2001 - 02:50:01 CDT
 |
 |