Re: Stored Procedures and Packeges

Hi,

You can select the source code of the stored procedure by querying the view user_source (or DBA_SOURCE if you have the privileges).

HTH Peter

"alessandro rodilosso" <a.rodilosso_at_esalab.it> wrote in message news:9ajqfd$spa$1_at_pinco.nettuno.it...
> Hi there,
> does anyone know if there's a way to find out
> all infos about implemented stored procedures in
> oracle packages such as
> 1) the listing of all the sp within the package
> 2) the definition of each sp
>
> I'm implementing a tool that must collect a listing of
> the sp within a given schema.
>
> I know there's the package DBMS_DESCRIBE
> but it does not satisfy me for all my needs
>
> I prefer you answer me to this address
>
> a.rodilosso_at_esalab.it
>
> Thank you
>
>
> Alessandro Rodilosso
>
>
>
>
>
>
>
Received on Tue Apr 17 2001 - 22:08:04 CEST