how do i identify package specification objects ?

[Advocate]

reverse-engineering 9i application for documentation ...

am i missing something here as i cant find anything obvious in the dictionary, documentation, tek-tips, google etc ?

i want to identify which package procs/funcs are declared in the package spec (public) or just in the pkg body (private) ...

got dba_procedures for the list of pkg objects ...

if anybody can help me please ?


regards, david - no such thing as problems - only solutions.

 

[SantaMufasa]

Advocate,

Following is code that lists the OWNER, PACKAGE name, and global/public PROCEDURE and FUNCTION names for all application users a database:

select owner, name, ltrim(text) text
  from dba_source
 where owner not in ('SYS','SYSTEM','DBSNMP')
   and (text like '%PROCEDURE%' or text like '%FUNCTION%')
   and substr(ltrim(text),1,2) <> '--'
 order by 1,2,3;

OWNER      NAME                 TEXT
---------- -------------------- --------------------------------------
TEST       MATRIX               FUNCTION matrix (query_in in VARCHAR2)
           NO_WEEKENDS          FUNCTION no_weekends(p_date1 IN DATE, 
           PR_TEST_PROCEDURE    PROCEDURE PR_TEST_PROCEDURE
**********************************************************************

To find the non-global/private PROCEDURE and FUNCTION names visible within a PACKAGE BODY only, we could formulate a MINUS operation. Let us know if you need help on such.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]