Re: Acessing stored procedures using sqlplus

all_source and all_arguments are dictionary views. You need to select from them.
To retrieve the definitions use
describe all_source
and
describe all_arguments

and, o yes, RTFM

Hth,

--
Sybrand Bakker, Oracle DBA
<payal_at_corvia.com> wrote in message news:82mfnf$o9q$1_at_nnrp1.deja.com...
> Hi
>
> I did try 'show all_arguments' and 'show all_source', it doesnt work
> I also did help on show:
>
> The only arguments it supports is:
>
>
> SHO[W] option
>
> where option represents one of the following terms or clauses:
>
> system_variable
> ALL
> BTI[TLE]
> ERR[ORS] [{FUNCTION|PROCEDURE|PACKAGE|PACKAGE BODY|TRIGGER|
> VIEW|TYPE|TYPE BODY} [schema.]name]
> LNO
> PARAMATERS [parameter_name]
> PNO
> REL[EASE]
> REPF[OOTER]
> REPH[EADER]
> SGA
> SPOO[L]
> SQLCODE
> TT[ITLE]
> USER
>
> Show all also does not list the procedures and the packages
>
> Any more ideas???
> Thanks a tonne.
>
> Payal
> In article <384d5e15_1_at_news.cadvision.com>,
> "Terry Dykstra" <tdykstra_at_cfol.ab.ca> wrote:
> > all_arguments shows all packages, procedures etc. all_source gives
> you the
> > code.
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> > Check out Sybase Developer's Network: http://www.sybase.com/sdn
> >
> > <payal_at_corvia.com> wrote in message news:82jlnt$mm8
> $1_at_nnrp1.deja.com...
> > > Hi
> > >
> > > I need to know how to access my stored procedures or packages
> > > using sqlplus in order to compile them and access them. Is there
> > > a table in sql that has a list of all the stored procedures and
> > > packages. Where are they stored??
> > >
> > > I can put a tored procedure in sql, using a file and then run it.
> > > Is there a command like 'show procedure some_procedure' or
> > > 'edit procedure some_procedure'. run just compiles a procedure.
> > >
> > > Thanks
> > > payal
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Dec 08 1999 - 16:22:23 CST