Re: Viewing Package Body Source Code..,

In article <tketchum-1605961341220001_at_tketchum.uoregon.edu>,

   tketchum_at_oregon.uoregon.edu (Tim T Ketchum) wrote:
>
>Is there any way to view the Package Body source code of a package you
>don't own? It appears that getting EXECUTE access isn't sufficient, yet
>it appears that that is the only grant privilege associated with packages.
>
>thx in advance,
>
>-tim
>

select owner,

        name,
        type,
        text
        from     sys.dba_source
        where    owner != 'SYS' 
         order by owner,
         name,
         type,
         line;
 

In the text you will find the body for packages.

Good Luck !!! Received on Fri May 17 1996 - 00:00:00 CEST