Re: How to get text of a stored package?

Art Shen wrote:

> 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! =-----

Go to http://www.quest.com.

Download a trial version of TOAD or SQL Navigator. Install it. Grab your code. Remove the software after the trial period is over unless you like it and have sufficient budget.

Daniel A. Morgan Received on Sat Jul 21 2001 - 16:37:15 CDT