trigger错误:trigger * is invalid and failed re-validation
点击右边红色标题查看本文完整版:trigger错误:trigger * is invalid and failed re-validation
create or replace trigger test_trigger
before insert on test
for each row
declare
has_count integer;
begin
select count(*) into has_count
from test
where state in ( '0 ', '1 ')
and key = :new.key
and rownum = 1;
if has_count > 0
raise_application_error (-2000, '此号码不允许录入 ');
end if;
end;
表test有key和state两个字段
向表中插值时报错:“trigger 'YWZC.TEST_TRIGGER ' is invalid and failed re-validation”
请教各位了,类似这样trigger * is invalid and failed re-validation 的错误怎么解决?
------解决方法--------------------
You can do this in Oracle9i using the command:
ALTER SYSTEM SET "_system_trig_enabled "=FALSE;
------解决方法--------------------
trigger * is invalid and failed re-validation
if 语句少了then吧
------解决方法--------------------
这样没用吧!你判断重复就触发,触发完了还是会insert进去的。
触发器不能阻止操作。