Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Stored Procedures and Packeges

Re: Stored Procedures and Packeges

From: Paul Drake <paled_at_home.com>
Date: Sun, 08 Apr 2001 19:43:16 GMT
Message-ID: <3AD0BF51.B6279C24@home.com>

look in the server filesystem in %ORACLE_HOME%\rdbms\admin\

alessandro rodilosso wrote:
>
> 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 Sun Apr 08 2001 - 14:43:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US