Re: How to list exported packages & thier source?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 3 Jan 2001 06:58:29 +0100
Message-ID: <93061n$8ajtf$2@ID-62141.news.dfncis.de>

select owner, object_name from all_objects where object_type in ('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION')

select text from all_source where owner = <owner above> and name = <name above>
order by line

Hth,

Sybrand Bakker, Oracle DBA

"Daniel" <dlrubinANTI-SPAM_at_yahoo.com> wrote in message news:3A52B3F2.2BB9AE88_at_yahoo.com...
> Hi,
> There are several packages which the admin of my oracle system has
> exported to be available to me. How can I list the names of those
> packages and their contents, and how can I view the source code for
> them?
>
> Thanks,
> Daniel
>
> --
> To reply to me directly, please remove "ANTISPAM" from the reply-to
> email address.
>
>
Received on Tue Jan 02 2001 - 23:58:29 CST