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

"@rennes" <l.sass_at_omp-transport.com> a écrit dans le message 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
>
>

Hello,
This is the query I use under O8i to list package def

select text from all_source t
where t.name='PKG_ANOMALY' and t.type ='PACKAGE' and (upper(t.text) like 'PROCEDURE%' or upper(t.text) like 'FUNCTION%');

it works quite well Received on Mon Nov 17 2003 - 08:25:02 CST