Can I get All objects related to Any(one) package

[ahmad_anees]

Can I get all objects which are defined in Packge.( through SQL)


Any thread or hints will be apreciated.

[davey23uk]

Originally posted by ahmad_anees
Can I get all objects which are defined in Packge.( through SQL)


Any thread or hints will be apreciated.

not quite sure what you mean but maybe user/dba_dependencies is what you are after

[ahmad_anees]

Originally posted by ahmad_anees
Can I get all objects which are defined in Packge.( through SQL)


Any thread or hints will be apreciated.

Lets Suppose There is one Packge "arthOperation" in that i used(defined/created) functions for addision,subtraction. and procedures for devision and multiplication. so now i want all procedure and function of this package .
I want sql through which i can get this result.

Packge
arthOperation under it these objects

Function: addision,subtraction
Procedure : devision, multiplication

I think now it would be more cleare .

[davey23uk]

Originally posted by ahmad_anees
Lets Suppose There is one Packge "arthOperation" in that i used(defined/created) functions for addision,subtraction. and procedures for devision and multiplication. so now i want all procedure and function of this package .
I want sql through which i can get this result.

Packge
arthOperation under it these objects

Function: addision,subtraction
Procedure : devision, multiplication

I think now it would be more cleare .

take a look at user_procedures, object_name will be the package name
procedure_name will be the procedure