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

In SQL*Plus try this:

SET PAGESIZE 1000
COLUMN text FORMAT a90
 SELECT text FROM user_source
   WHERE name like 'YourProcFuncOrPAckageNAme' (o==> name = '....')    ORDER BY line;

Hakan Eren

Joseph S. Testa wrote:

> 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).
Received on Tue Dec 16 1997 - 00:00:00 CST