Re: How to get text of a stored package?

From: Art Shen <artbecky_at_home.com>
Date: Sat, 21 Jul 2001 21:36:30 GMT
Message-ID: <GFG37.154304$W02.2680014@news1.rdc2.on.home.com>

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:tkub4aeinm902c_at_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
>
>
>

Thanks. However, these packages are not from Oracle but from our developers who wrote the codes many yers ago.

Art Received on Sat Jul 21 2001 - 16:36:30 CDT