FreeLists / oracle-l / RE: Procedures within Packages

[Raj Jamadagni <rjamya@xxxxxxxxx>]

Stephan,

beware of the dynamic SQL part ... I have a package that uses only dynamic sql, 
don't ask why.
Such tool might be insufficient for dynamic sql.

Raj
--- Stephen.Lee@xxxxxxxx wrote:
> 
> If I get time (don't hold your breath), I might fiddle with a ksh script.
> 
> But a suggestion to get you started is to head to asktom.oracle.com and
> search for getallcode.  He has a couple of seriously handy scripts
> (getcode.sql and getallcode.sql) for extracting the source code for a
> schema.  Even if you don't intend to use them for this project, your life
> will be happier if you get them anyway.  I think what I would do is suck out
> the code with Tom's scripts, then use ksh to parse through the files and
> look for words like FROM, INTO, PROCEDURE, FUNCTION using a case insensitive
> search (e.g. [Ff][Rr][Oo][Mm]).


=====
Best Regards
Raj
---------------------------------------------------------
select mandatory_disclaimer from company_requirements;

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------