Database Administration (MOSC)

MOSC Banner

compile invalid objects related to a given table (in the right order)

edited Mar 18, 2010 2:19AM in Database Administration (MOSC) 7 commentsAnswered
 I'm working on a post purge routine that will recompile all dependent objects on a given table (and the dependents' dependents) in the correct order.  I've taken a stab at it but can't seem to get it right (can't seem to get the right order).  I have a test case below.

1. objects invalidated by change in target table

OWNER                          OBJECT_TYPE  OBJECT_NAME
------------------------------ ------------ -----------------------------
PROD                           FUNCTION     CHECK_UPCS_EXIST
PROD                           PACKAGE      APPROVE_PO_CHANGE
PROD                           PACKAGE BODY APPROVE_PO_CHANGE
PROD                           PROCEDURE    CANCEL_PO
PROD                           PROCEDURE    DETAIL_ENTER_RECEIPT
PROD                           PROCEDURE    OPEN_PO_CHANGE
PROD                           PROCEDURE    OPEN_REC_CORRECTION

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center