日志表(自用)

DROP TABLE ELOG PURGE; CREATE TABLE ELOG( ID NUMBER(6) GENERATED AS IDENTITY, START_TIME TIMESTAMP, END_TIME TIMESTAMP, DURATION AS (END_TIME-START_TIME), SUC CHAR(1), ERROR_MESSAGE CLOB, ERROR_DETAIL CLOB);

DECLARE   STIME TIMESTAMP;   ERROR_DETAIL CLOB;   ERROR_MESSAGE CLOB; BEGIN   STIME:=SYSTIMESTAMP;   --   -- 要执行的代码   --   INSERT INTO ELOG(START_TIME,END_TIME,SUC,ERROR_MESSAGE,ERROR_DETAIL)                 VALUES (STIME,SYSTIMESTAMP,'T',NULL,NULL);   COMMIT; EXCEPTION   WHEN OTHERS THEN     ROLLBACK;     ERROR_MESSAGE:=SQLERRM;     ERROR_DETAIL:=DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;     INSERT INTO ELOG(START_TIME,END_TIME,SUC,ERROR_MESSAGE,ERROR_DETAIL)                 VALUES(STIME,SYSTIMESTAMP,'F',ERROR_MESSAGE,ERROR_DETAIL);     COMMIT; END; /