3 Replies Latest reply on Jul 15, 2013 3:22 PM by 509894

    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.