Re: How to get text of a stored package?

Thanks everyone. But the thing is I don't have DBA privilege , and the xxx_source only display the defination of the package, not the detail(package body) of each procedures within that package. I need to know the detail message of the those procedures and functions.

Art

TurkBear <noone_at_nowhere.com> wrote in message news:5tguktkh9oa8726hc8knu27nvrh577ukku_at_4ax.com...
>
> 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:37:36 CDT