Max # lines in stored package
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.comReceived on Sun Mar 17 1996 - 00:00:00 CET