Re: how can i get all procedure-names of a package by using of sql?

From: Andre van Winssen $andrew$ <andrew-no-spam-svp_at_info.nl>
Date: Tue, 19 Feb 2002 10:36:42 +0100
Message-ID: <3c721caa$0$225$4d4ebb8e@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
>
Received on Tue Feb 19 2002 - 03:36:42 CST

This message: [ Message body ]
Next message: Michael Mahnke: "how can I connect to Oracle-DB-Server with IP and Port under ODBC ?"
Previous message: Thao Ngo: "how can i get all procedure-names of a package by using of sql?"
In reply to: Thao Ngo: "how can i get all procedure-names of a package by using of sql?"
Next in thread: Mark D Powell: "Re: how can i get all procedure-names of a package by using of sql?"
Reply: Mark D Powell: "Re: how can i get all procedure-names of a package by using of sql?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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