Re: How to get text of a stored package?

Art Shen wrote:

> 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

Do a describe on dba_source. What you will need to do is write a query to retrieve all rows related to the object in question.

Daniel A. Morgan Received on Sat Jul 21 2001 - 16:36:31 CDT