RE: Get Package, Re-write, Re-compile...

From: "Post, Ethan" <Ethan.Post@xxxxxx>
To: "Stephane Faroult" <sfaroult@xxxxxxxxxxxx>
Date: Fri, 19 Nov 2004 14:59:41 -0600

Think the 9i docs say the same thing but just after the section on that
it implies the limit for both is 32K and it didn't sound like per line,
of course the Oracle docs could be wrong..guess I need to try it though.

-----Original Message-----
From: Stephane Faroult [mailto:sfaroult@xxxxxxxxxxxx]=20
Sent: Friday, November 19, 2004 2:56 PM
To: Post, Ethan
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Get Package, Re-write, Re-compile...

Perhaps something to try. Notwithstanding the fact that you must be=20
careful when executing DDL with the dbms_sql package, there is (at least

in the 10G version) an overloaded 'parse' function which takes an array=20
of varchar2 in lieu of the customary single varchar2 as the text for the

statement (basically, you have an array with one row per line of=20
statement). The comments say that 'conceptually' it behaves as if the=20
various elements were concatenated. The question is whether the concept=20
extends as far as breaking at 32K. Because otherwise you can probably go

as far as 32K rows of 32K each (I hope you wont blow the limit ;-)). I=20
would have a look there if I were you.

SF

Post, Ethan wrote:
--
//www.freelists.org/webpage/oracle-l

RE: Get Package, Re-write, Re-compile...

Other related posts: