实例
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博客 ” ,链接:http://blog.itpub.net/23033727/viewspace-631439/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23033727/viewspace-631439/