刚刚开发的同事来找我,在内网数据库上为一个表添加了字段后,再创建存储过程时候报错,提示新加的这个字段无效
Warning: Procedure created with compilation errors.
SQL> show error
Errors for PROCEDURE CB_DATE_MODIFY:
LINE/COL ERROR
-------- -----------------------------------------------------------------
37/20 PL/SQL: SQL Statement ignored
37/27 PL/SQL: ORA-00904: "A3"."OLD_ID": invalid identifier
之前也遇到过类似的问题,估计跟shared pool有关系,因为是内网测试库,所以直接flush 了shared pool
SQL> alter system flush shared_pool; System altered. SQL> create or replace procedure cb_date_modify is
。。。。
。。。。
47 / Procedure created.