Re: PL/SQL Tip of the Month

From: Rudi Demeulenaere <rdm_at_mentor.spamnothanks.be>
Date: Thu, 07 May 1998 22:24:14 +0200
Message-ID: <3552186E.882EAB89_at_mentor.spamnothanks.be>


info_at_revealnet.com wrote:

> Have you ever wondered how you can get a list of the names of the procedures
> and functions in your package? The data dictionary does not, unfortunately,
> offer a view that contains the list of elements defined in a package
> specification (that would be so incredibly useful!). There are, however, a
> couple of ways to get at this information.

[Quoted] [Quoted] Speaking of which,does anyone know a way to export the *packages* (+proc's, functions) of a *user*
[Quoted] and only the packages (so no tables, not even the empty versions of them) ? This in a way that these can be imported in another database (so without exporting
the whole database).

A lead to a solution is also welcome.

Thanks in advance,

r u d i
(remove anti-spam measure from reply-address) Received on Thu May 07 1998 - 22:24:14 CEST

Original text of this message