RE: pls-00123 - Program too Large

Hi Christian,

Didn't they remove their limitation on 64K ? I don't have access to Metalink now, can't look at the notes.

>
>
> 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
> >
> --------------------------------------------------------------------
> > 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).
>
>
> =====
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> ctrassens_at_yahoo.com
> ctrassens_at_hotmail.com
> Phone : 541149816062
>

-- 
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).