Re: Which table holds the package body?

Hi,

The view that holds your package body is user_source (or all_source, dba_source).

To get the dependencies of a package, you can proceed as following : select object_id
from dba_objects
where object_name = '...' and

       object_type = 'PACKAGE BODY'
-> object_id for your package body

Then with that object_id :

select b.Object_Name
from sys.Dependency$ a, dba_objects b
where a.d_obj# = ... and

       a.p_obj# = b.object_id

Voila,

HTH, Regards,

Laly.

-- 
Use our news server 'news.foorum.com' from anywhere.
More details at: http://nnrpinfo.go.foorum.com/