Re: Which table holds the package body?

Praveen wrote:

> Hi..All,
>
> I am trying to find out whether Oracle stores the dependencies of a Package
> i.e.. the associated Procedures/Functions in a table. So, when I query for a
> package in the table, I should get the name of the object & type
> (function/procedure...) ?
>
> Secondly, all_source table only stores the header of the package, where can i
> find the body of the package?
>
> TIA,
>
> Regards,
>
> PM

Q1:
SELECT object_name
FROM all_objects
WHERE object_name LIKE '%DEPEND%';

Q2:
Your statement is incorrect. all_source contains both the header and the body. Look again.

Daniel Morgan Received on Mon Nov 11 2002 - 12:38:04 CST