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”
请教各位了
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”
请教各位了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货