Re: Getting Stored Proc from Oracle 8.0.5

Hi,
  you could try specifying the name = whatever one you are trying to look at...

  I'm not sure what you mean by ..."not just 1 requested..." without having specified the one that you wanted.

hth,
cindy

Mike Krolewski wrote:

> In article <920j04$ul1$1_at_nnrp1.deja.com>,
> stemp1ar_at_my-deja.com wrote:
> > Is there any other way using SQLPLUS to get the source code for a
> > stored procedure and retrieve only the 1 procedure requested...
> > Currently using: SELECT text FROM ALL_SOURCE WHERE owner = USER; will
> > give all of the procedures not just 1 requested...
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> There are a series of 3rd party tools that work well --
>
> BMC SQLProgrammer $150.00 and $1000 depending on parts.
> Quest SQLNavigator $900 to $1500 ( I think )
> Quest TOAD ??
>
> Shareware version of TOAD : www.toadsoft.com $FREE or next to it
>
> There are others...
>
> Most can be downloaded in trial or complete form.
>
> --
> Michael Krolewski
> Rosetta Inpharmatics
> mkrolewski_at_rii.com
> Usual disclaimers
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 22 2000 - 19:02:15 CST