Re: Acessing stored procedures using sqlplus

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Tue, 7 Dec 1999 12:23:29 -0700
Message-ID: <384d5e15_1@news.cadvision.com>

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.
Received on Tue Dec 07 1999 - 13:23:29 CST