Hmmm, in 9.2 at least every proc/func has an entry whether there are params
or not.
"Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message
news:bpal59$1lrvg6$1_at_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 - 09:33:59 CST
