3 Replies Latest reply: Jul 15, 2013 10:22 AM by 509894 RSS

    which dictionary view has package defination


      I have a 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.