Re: How to get text of a stored package?

From: Art Shen <artbecky_at_home.com>
Date: Sat, 21 Jul 2001 21:36:52 GMT
Message-ID: <fNK37.155231$W02.2691251@news1.rdc2.on.home.com>

Thank you, that makes sense. I'll try it next monday. Have a good weekend.

Art

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:9inn4602rc3_at_drn.newsguy.com...
> In article <gVF37.154004$W02.2678374_at_news1.rdc2.on.home.com>, "Art says...
> >
> >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
> >
> >
>
> You either need:
>
> o access to DBA_SOURCE. Your DBA can grant you select on just that view.
>
> o CREATE ANY PROCEDURE to see package bodies, or EXECUTE|CREATE ANY
PROCEDURE to
> see standalong procedures/functions in ALL_SOURCE
>
> --
> Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sat Jul 21 2001 - 16:36:52 CDT