SCHEDULE

테이블생성

 create table scott.tb_jobs ( log_dt date );

procedure 생성

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;
/