oracle 存储过程异常处理

 

error varchar2(500);

 

EXCEPTION
         WHEN OTHERS
         THEN
            BEGIN
               ROLLBACK;
                  error:=SUBSTR(SQLERRM, 1, 200);
                  insert into test values(appValue,error,sysdate);
                  COMMIT;
               RAISE;
            END;