Re: Package question.

From: Vijay Darekar <vijayd_at_worldnet.att.net>
Date: 1997/08/24
Message-ID: <34012B0B.2648_at_worldnet.att.net>#1/1


Stephen wrote:
>
> Hello all,
>
> I have a question about package.
> How to list the content of the package? When I type "select * from
> dba_object_size", it can show the package and its owner. But how can I
> know the content of the particular package?
>
> Moreover, is the package can be used by its owner? If so, how can grant
> the privilege to other users?
>
> Thanks,
> Stephen

You can get the package and package body containts from the all_source table.

select text
from all_source
where type in ('PACKAGE','PACKAGE BODY') and name = package_name
order by line

Vijay Darekar Received on Sun Aug 24 1997 - 00:00:00 CEST

Original text of this message