实验目的：验证schema object的关联
1.建立test_table表和test_proc过程

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;
/
2.查看test_proc的状态为 valid
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';
 
OBJECT_NAME STATUS
----------- -------
TEST_PROC   VALID
3.修改test_table表结构
SQL> ALTER TABLE test_table ADD col3 NUMBER;
4.重新查询test_proc状态为invalid
SQL> SELECT OBJECT_NAME, STATUS FROM USER_OBJECTS WHERE OBJECT_NAME = 'TEST_PROC';
 
OBJECT_NAME STATUS
----------- -------
TEST_PROC   INVALID
5.重新编译test_proc状态
 
SQL> EXECUTE test_proc

ITPub博客

《concept》学习之路一：how schema objects can create dependencies

最新文章