在SOURCE用户下,在执行存储的时候报错:
ORA-04045:在重新编译/重新验证YLC.TRI_DDL_TEST02时出错.
有点奇怪,为何会报用户YLC下的触发器无法编译呢?
那就单独去编译下这个触发器:
[aix1]:[*]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 17 15:18:45 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> alter TRIGGER YLC.TRI_DDL_TEST02 COMPILE;
alter TRIGGER YLC.TRI_DDL_TEST02 COMPILE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [16606], [4], [0], [0x000000000],
[], [], [], [], [], [], [], []
SQL>
去metlink上面查了一下,是由于这个TRIGGER中错误引用绑定变量导致
去掉trigger中的绑定变量,重新编译,OK