Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do i know the list of procedure of a package
"@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