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

    which dictionary view has package defination

    user12048533

      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.