"Andre van Winssen \(andrew\)" <andrew-no-spam-svp_at_info.nl> wrote in message news:<3c721caa$0$225$4d4ebb8e_at_news.nl.uu.net>...
> do a describe of the package, e.g.
> SQL> desc DBMS_JOB
>
> or use the DBMS_DESCRIBE procedure. See the PLSQL manual.
>
> Andre
>
> "Thao Ngo" <Thao.Ngo_at_t-systems.de> wrote in message
> news:3C7218EA.399668FD_at_t-systems.de...
> > Hello NG,
> >
> > how can i get all procedure-names of a package by using of sql?
> >
> > Thank,
> > Thao
> >
If by chance you are on an older version of Oracle where desc will not
work on a package then look at the all_arguments dictionary view which
became available with version 7.2 and higher.
Received on Tue Feb 19 2002 - 10:12:02 CST
