This discussion is archived
3 Replies Latest reply: Jul 15, 2013 8:22 AM by 509894 RSS

which dictionary view has package defination

user12048533 Newbie
Currently Being Moderated

I have a 10.2.0.3 database. I have a lot of packages under one schema. Each package contains few procedures and functions.

I need to identify which one is a function and which one is a procedure within a package. I can user dba_procedures to get the column of procedure_name.

However, the procedure_name column contains both function and procedure names.

 

Thanks a lot for any help on this.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points