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