Re: How to get the code of the stored procedure/package?

Grace Tsai wrote:

> Does anybody know how to get the code of the stored procedure/package?
> I lost some of the files of procedures and packages, but I installed
> them in sqlplus before I lost them. How to get the codes? Any help would
> be greatly appreciated. Thanks in advance.
>
> Grace Tsai
> Brookhaven National Lab

do you have eneterprise manager?, using schema manager, you can see all the code, that is the easiest method to get it.

joe

--
Joseph S. Testa, Oracle Database Administrator, mailto:jtesta_at_scioto.net
(home)
Vice-President Ohio Oracle Users Group,
See the Oracle FAQ at http://www.orafaq.org
Try http://web.scioto.net/jtesta that is also the place to find the FREE,
drop column script
ICQ UIN:  2832230(&oracle, home).