Max # lines in stored package

From: Artur A Akerman <akermana_at_ix.netcom.com>
Date: 1996/03/17
Message-ID: <4ihncd$9e7_at_dfw-ixnews3.ix.netcom.com>#1/1


In <4ibd20$p2e_at_romeo.logica.co.uk> marrowm_at_logica.com (Matt Marrow) writes:
>
>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 #

About max # of lines in the package ... I think it is a limitation of Windows ORACLE driver. You can not execute one statement bigger than 32K. I had to split my package into 2. Other solution is move script to the server and execute it there.

                                   Artur Akerman
                                   akermana_at_ix.netcom.com
Received on Sun Mar 17 1996 - 00:00:00 CET

Original text of this message