:
If the definition of object A references object B, then A is a dependent object on B, and B is a referenced object for A.
注意区别外键约束的reference,constraints也是schema object,但不止外键约束是dependencies object,view也是,存储过程等也可能是
Oracle会自动使dependent object与referenced objects同步, 只在referenced object的改变影响到了dependent object,dependent object才会标记为invalid
这时dependent object必须重新编译(recompiled),在使用dependent object时会自动重新编译
示例:
CREATE TABLE test_table ( col1 INTEGER, col2 INTEGER );
CREATE OR REPLACE PROCEDURE test_proc
AS
BEGIN
FOR x IN ( SELECT col1, col2 FROM test_table )
LOOP
-- process data
NULL;
END LOOP;
END;
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC'; ---VALID
对表加列并不会影响到依赖的存储过程:
SQL> ALTER TABLE test_table ADD col3 NUMBER;
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC'; ---VALID
更改列的类型会影响到依赖的存储过程:
SQL> ALTER TABLE test_table MODIFY col1 VARCHAR2(20);
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC'; --INVALID
执行存储过程时会自动重编译:
SQL> EXECUTE test_proc
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC'; --VALID