バックアップトリガ:ADDC 3
3167 ワード
CREATE OR REPLACE TRIGGER "XMV502"."ADDC3"
before insert on bd_cubasdoc
for each row
declare
-- local variables here
i number(1);
begin
select count(1)into i from bd_cubasdoc
where custname=:new.custname
or (engname=:new.engname and length(:new.engname)>3) --
or (taxpayerid=:new.taxpayerid and length(:new.taxpayerid)>3);--
if i>0 or
regexp_like(:new.custname,'[[:space:]]')
then
begin
raise_application_error(-20001,' , !');
end;
end if;
end;
XMV502