Re: Show text of stored procedure

From: David Zlotchenko <zlotchen_at_voyager.rtd.utk.edu>
Date: 1 Dec 1999 16:12:05 GMT
Message-ID: <823hcl$jrt$1@penn.dii.utk.edu>

Look into table user_source. the source will be in fiels text.

David.

alan_perot_at_my-deja.com wrote:
: I am trying to find a way (query, etc.) to view
: the text of a stored procedure in Oracle 8
: without having the source. I looked through the
: documentation and can't find anything, or any
: standard user or dba tables or views that might
: contain the text. The particular procedures I am
: interested in are inside a package, if that helps.
:
: Thanks
: Alan
:
:
: Sent via Deja.com http://www.deja.com/
: Before you buy.

--
--
David Zlotchenko
E-mail: zlotchen_at_cs.utk.edu
WWW: http://www.oars.utk.edu/~zlotchen Received on Wed Dec 01 1999 - 10:12:05 CST