实例
declare
error_1578 exception;
pragma exception_init(error_1578,-1578);
n number;
begin
for cursor_lob in (select rowid r, &&lob_column from &table_owner.&table_with_lob) loop
begin
n:=dbms_lob.instr(cursor_lob.&&lob_column,hextoraw('889911')) ;
exception
when error_1578 then
insert into corrupted_data values (cursor_lob.r);
commit;
end;
end loop;
end;
/
当出现1578异常（块坏）时，触发error_1578这个异常，执行insert into corrupted_data values (cursor_lob.r);
declare
error_1578 exception;
pragma exception_init(error_1578,-1578);
n number;
begin
for cursor_lob in (select rowid r, &&lob_column from &table_owner.&table_with_lob) loop
begin
n:=dbms_lob.instr(cursor_lob.&&lob_column,hextoraw('889911')) ;
exception
when error_1578 then
insert into corrupted_data values (cursor_lob.r);
commit;
end;
end loop;
end;
/
当出现1578异常（块坏）时，触发error_1578这个异常，执行insert into corrupted_data values (cursor_lob.r);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23033727/viewspace-631439/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
dbms_lob.instr
请登录后发表评论
登录
全部评论
