RE: Procedures within Packages

From: Raj Jamadagni <rjamya_at_yahoo.com>
Date: Thu, 1 Jul 2004 04:05:47 -0700 (PDT)
Message-ID: <20040701110547.14128.qmail@web50009.mail.yahoo.com>

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_at_DTAG.Com 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Thu Jul 01 2004 - 06:02:24 CDT