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

Home -> Community -> Usenet -> c.d.o.server -> Re: how do i know the list of procedure of a package

Re: how do i know the list of procedure of a package

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Mon, 17 Nov 2003 15:12:22 +0100
Message-ID: <bpal59$1lrvg6$1@ID-152732.news.uni-berlin.de>


"@rennes" <l.sass_at_omp-transport.com> schrieb im Newsbeitrag news:bpajue$12t$1_at_s1.read.news.oleane.net...
> Hello,
>
> how do i know the list of function and procedure in a package ?
> it's in oracle 7
>
> i wan't to know that by sql.
>
> Thanks
>

Not sure if this was already available in 7 (desupported long ago!), but maybe check the view ALL_AGRUMENTS of the data dictionary. But it shows only functions and procedures which *have* arguments. Otherwise You are stuck with digging in ALL_SOURCE ...

... did by any chance somebody leave
an undocumented mystery behind him
before he went off
and You are now the one to ask The Oracle ?

for more information goto http://tahiti.oracle.com

hth, Jan Received on Mon Nov 17 2003 - 08:12:22 CST

Original text of this message

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