Re: Scanner for PLSQL to show the structure of the packages

I am tempted to say RTM to your request ... but I won't. <g>

How about this:

SQL> DESC package_name

or how about this:

SELECT argument_name, data_type, default_value, in_out FROM all_arguments
WHERE owner = schema_name
AND package_name = package_name (or IS NULL) AND object_name = procedure_or_function_name ORDER BY position;

All of this information is in the data dictionary.

Daniel Morgan

Adam Sauer wrote:

> Hello,
>
> I am working with PLSQL. Does somebody know, whether there is a kind
> of a scanner, to scan a package to visualize all procedures and
> sub-procedures used in this package.
>
> The possibilities of the PLSQL-Developer are not sufficient for my
> problem.
>
> Thank you for your response.
>
> Adam Sauer
Received on Fri Feb 22 2002 - 18:00:02 CET