This comes from $ORACLE_HOME/rdbms/admin/utldtree.sql I expected to see a dependency here, but did not. Any idea? Im testing because I need to use these views to write some code.
CREATE OR REPLACE PACKAGE X IS PROCEDURE Y; END; CREATE OR REPLACE PACKAGE BY X IS PROCEDURE Y IS BEGIN NULL; END Y; END X; CREATE OR REPLACE PACKAGE XX IS PROCEDURE YY; END; CREATE OR REPLACE PACKAGE BODY XX IS PROCEDURE YY IS BEGIN X.Y; -- not the dependency END YY; END XX; I then execute procedure DEPTREE_FILL('PACKAGE BODY','USER','XX); from utldtree.sql, I then query deptree_temptab and there are no dependencies. What am I missing? OBJECT_ID REFERENCED_OBJECT_ID NEST_LEVEL SEQ# ---------- -------------------- ---------- ---------- 205517 0 0 0 Im lost here.... the procedure doesnt have alot of documentation. Should REFERENCE_OBJECT_ID be populated with the object_id of package X? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).