Re: How to get text of a stored package?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:36:24 GMT
Message-ID: <tkub4aeinm902c@beta-news.demon.nl>

"Art Shen" <artbecky_at_home.com> wrote in message news:gVF37.154004$W02.2678374_at_news1.rdc2.on.home.com...
> Hi all,
>
> I can only get the text of a procedure or head of package from
all_source.
> How can I get a full content of package body?
> Oracle 7.3.4
>
>
> Thanks
>
>

The only location is xxx_source.
The package body may have be deliberately 'wrapped' by Oracle, ie stored in binary form, as their code is company secret. Without knowing which package you try to retrieve no conclusive answer is possible.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sat Jul 21 2001 - 16:36:24 CDT