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

OK, this one is going to AskTom as soon as his queue clears up.  Would
anyone actually want his job?  We need to put Tom in for a Nobel prize
or something, he exhibits an amazing amount of patience and effort with
ol AskTom.

Will keep you posted.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Post, Ethan
Sent: Thursday, November 18, 2004 2:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Get Package, Re-write, Re-compile...

Here is the situation, I have written a PL/SQL package that grabs source
code for other packages from DBA_SOURCE, goes through each line, inserts
instrumentation among other things, and then inserts that source into a
temporary table.  This can all be accomplished using a simple call to
the package.  However, to recompile the new package I spool out the new
source to a file and run the file, this happens via SQL*Plus.=3D20

Ideally I would like to recompile the new package using PL/SQL however I
think DBMS_SQL has a limit of 32K and I think varchar2 limit is also 32K
which I could use for execute immediate.  Some of these packages are >
1MB in size.  Besides writing some sort of java/c wrapper can anyone
think of a way to do this?

Thanks!
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: