Re: Stored Package

Matt Marrow wrote:
>
> If the package is small, the buffer is useful, but for various reasons some of
> our packages are several thousand lines long - scrolling back and forth
> through this lot can be very tedious - if you store the query to retrieve the
> 'n'th line from package 'x' as a .sql file this can be a lot more convenient.
>
> While I'm here, has anyone ever reached the maximum number of lines allowed
> in a package? - we seem to have hit a boundary here, but I don't know what the
> limits are - anyone know?
>
> Matt
>
> In article <Do8Btr.Ds9_at_statcan.ca>, youngpa_at_statcan.ca (Paul Young) wrote:
>
> >maybe I'm missing something here but ...
> >When we compile packages within PL/SQL, one at a time and there is a problem,
> >it is simple to find. Simply list the contents of the buffer (this includes
> >line numbers that PL/SQL references) then show errors. Having a window that
> >scrolls enough to include the whole package helps.
> >
> >Hope this helps.
> >
> >
> >PGY (Opinions expressed are mine and mine alone)
> >################################################################
> ># Paul Young #
> ># youngpa_at_statcan.ca #
> ># Statistics Canada #There is a maximum of 64KB parsed for Packages and procedures. I believe
that this limit will be doubled in v7.3. Received on Thu Mar 21 1996 - 00:00:00 CET