trigger+lob+ora-22275
CREATE OR REPLACE TRIGGER test
BEFORE DELETE OR UPDATE
ON table_A
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
as
l_blob blob;
begin
if updating then
insert into table_B(col_1,col_2)
values(:NEW.col_1, empty_blob())
return col_2 into l_blob;
dbms_lob.copy(l_blob,new.col_2,dbms_lob.getlength(new.col_2),1,1);
end if;
end;
BEFORE DELETE OR UPDATE
ON table_A
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
as
l_blob blob;
begin
if updating then
insert into table_B(col_1,col_2)
values(:NEW.col_1, empty_blob())
return col_2 into l_blob;
dbms_lob.copy(l_blob,new.col_2,dbms_lob.getlength(new.col_2),1,1);
end if;
end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/756652/viewspace-483889/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
DBMS_PROFILER(zt)
下一篇：
数据库集群服务器系统性能瓶颈分析(zt)
请登录后发表评论
登录
全部评论
