/** @description Unknown Errors occurs during the whole create and drop process*/
exception
when others then
rollback;
vn_err_code:=sqlcode;
vv_err_text:='PARTITION ERROR:'||substr(sqlerrm,1,180);
dbms_output.put_line(vv_err_text);
vi_log_status:= -1;
select sysdate into vd_end_date from dual;
on_statuscode := 1;
return;
end;
/** @description commit transaction, all success*/
commit;
vn_err_code:='0';
select sysdate into vd_end_date from dual;
/** @description Unknown Errors occurs during the whole process*/
exception
when others then
rollback;
vn_err_code:=sqlcode;
vv_err_text:=substr(sqlerrm,1,200);
dbms_output.put_line(vv_err_text);
vi_log_status:= -1;
select sysdate into vd_end_date from dual;
on_statuscode := 1;
commit;
/** END*/
end ;
/
exception
when others then
rollback;
vn_err_code:=sqlcode;
vv_err_text:='PARTITION ERROR:'||substr(sqlerrm,1,180);
dbms_output.put_line(vv_err_text);
vi_log_status:= -1;
select sysdate into vd_end_date from dual;
on_statuscode := 1;
return;
end;
/** @description commit transaction, all success*/
commit;
vn_err_code:='0';
select sysdate into vd_end_date from dual;
/** @description Unknown Errors occurs during the whole process*/
exception
when others then
rollback;
vn_err_code:=sqlcode;
vv_err_text:=substr(sqlerrm,1,200);
dbms_output.put_line(vv_err_text);
vi_log_status:= -1;
select sysdate into vd_end_date from dual;
on_statuscode := 1;
commit;
/** END*/
end ;
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12961536/viewspace-1061435/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12961536/viewspace-1061435/