触发器异常导致ORA-00604
这个故障,我暂时无解.记录着.
重建就可以好了.但过了一段时间,又会报错…..不知道是否触发 了bug.
但还好,几个月一次,还是可以忍受.用户不能使用,我重建trigger即可.
———————-
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 129, column 0:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
ORA-06550: line 129, column 0:
PLS-00103: Encountered the symbol “end-of-file” when expecting one of the following:
( – + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string>
disable and then enable it
it should be work well.
select *
–owner,name
from SYS.v_$db_object_cache
where type in (‘TRIGGER’,’PROCEDURE’,’PACKAGE’)
and (loads > 1 or KEPT=’YES’);
–owner,name
from SYS.v_$db_object_cache
where type in (‘TRIGGER’,’PROCEDURE’,’PACKAGE’)
and (loads > 1 or KEPT=’YES’);
» 转载保留版权：老陈 » 《触发器异常导致ORA-00604》» 本文链接地址：http://www.db110.com/%e8%a7%a6%e5%8f%91%e5%99%a8%e5%bc%82%e5%b8%b8%e5%af%bc%e8%87%b4ora-00604/» 如果喜欢可以： 点此订阅本站