Re: Stored Package

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 #
Received on Fri Mar 15 1996 - 00:00:00 CET