You can also use SQL PlusPlus (a freeware) to get the code of any
object (and edit it as well) with the following in SQL PLUS
EXEC s.GETSRC(procname, owner, 'PROCEDURE');
EXEC s.GETSRC(procname, owner, 'FUNCTION');
EXEC s.GETSRC(procname, owner, 'PACKAGE');
EXEC s.GETSRC(procname, owner, 'PACKAGE BODY');
And for triggers
EXEC s.GETSRC(tablename, owner);
regards,
M. Armaghan Saqib
- SQL PlusPlus : Add power to SQL Plus command line
- SQL Link for XL : Integrate Oracle with XL
- Oracle CBT with sample GL (Triggers and Forms Source Code included.
Download free: http://www.geocities.com/armaghan/
Ed Prochak <prochak_at_my-deja.com> wrote in message news:83dscd$1k5
$1_at_nnrp1.deja.com...
>
>
> Look in the USER_SOURCE table with something like:
>
> SELECT line, text
> FROM USER_SOURCE
> WHERE name = 'MY_PROCEDURE'
> ORDER BY line ;
>
> HTH
> Ed
>
>
> In article <83dls5$sj7$1_at_nnrp1.deja.com>,
> texas_mike_at_my-deja.com wrote:
> > How do I view the code behind the stored procedures in the database?
> >
> > Thanks.
> > --
> > -----------------------------
> > TEXAS_MIKE_at_MY-DEJANEWS.COM
> > Hey haven't we met?
> > -----------------------
>
>
> --
> Ed Prochak
> Magic Interface, Ltd.
> ORACLE Development, conversions, training and support
> 440-498-3700 magic_at_interfacefamily.com
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 17 1999 - 18:43:11 CST