Re: can I see the procedures in a package thru SQLPLUS???

"desc packagename" isnīt correct. Only "desc package.function" or "desc package.procedure"

But you can use "ALL_SOURCE" or "USER_SOURCE" for the sourcecode of these packages.

The easiest way is: Try T.O.A.D. from Quest-Software. This is one of the best products for looking and analysing objects in a database. For less money.

Have a nice day
  Gerd Volberg
  Opitz&Partner GmbH

NeilC wrote:

> You can try doing the following
>
> sql> desc packagename
>
> HTH neil
>
> James Belton wrote:
>
> > I want to be able to see which procedures are stored in a package or even
> > which package a procedure might be in, using SQLPLUS.
> >
> > I've trawled thru the SYS tables and views and can't find anything
> > obvious...... does anybody know how to do this???
Received on Wed Oct 27 1999 - 08:34:14 CDT