Re: How to get text of a stored package?

Or use Oracle's DBAStudio to access it..

"Daniel A. Morgan" <Daniel.Morgan_at_attws.com> wrote:

>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

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Sat Jul 21 2001 - 16:36:34 CDT