create table scott.tb_jobs ( log_dt date );
CREATE OR REPLACE PROCEDURE SCOTT.SP_INSERT_LOG_DATE IS BEGIN INSERT INTO SCOTT.TB_JOBS (LOG_DT) VALUES (SYSDATE); COMMIT; EXCEPTION WHEN OTHERS THEN ROLLBACK; END SP_INSERT_LOG_DATE; /