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