Re: Iterating through SPs/Packages and writing to external .txt file?

(Pete Cresswell) wrote:
> I'd like to be able to pull all the stored procedures and packages out of an
> Oracle DB and write them to a plain old text file.
>
> I'm guessing there's some way to iterate through various DB objects.
> Is there some way to do file I/O from SQL...or am I on the wrong track?

For 9i DBs look at DBMS_METADATA
Other wise you are stuck doing some PL/SQL coding. Received on Mon Dec 15 2003 - 19:30:12 CST