Procedure in which Package?

**bang_dba** · 08-13-2003, 06:53 AM

hi,
How to find which procedure is bundled under which package.
Is there any view for this.

**pando** · 08-13-2003, 07:19 AM

all_arguments.object_name

**marist89** · 08-13-2003, 08:16 AM

Dude, you're good. I learn something new everyday...

**bang_dba** · 08-13-2003, 08:37 AM

Originally posted by pando
all_arguments.object_name

Pando can u pls elaborate on this........

**abhaysk** · 08-13-2003, 08:45 AM

RTM for feild defn..

Code:

Select * from user_arguments where Object_Name='MY_PROC'
;

or 

Select * from all_arguments where Object_Name='MY_PROC'
;

Abhay.

**bang_dba** · 08-14-2003, 02:59 AM

oooops.....
Thanx abhay....

Well i was wondering why dba_arguments view is not there ?..
any specific reason behind this .....

Thread: Procedure in which Package?