1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| spool test.log
truncate table ... ;
commit;
select 'Before Insert' , to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual ;
DECLARE
err_code varchar(200);
err_msg varchar(200);
BEGIN
insert into TABLE1 (arg1, arg2)
select to_char(sysdate,'YYYYMMDD'), to_char(sysdate,'HH24MISS') from dual
commit;
EXCEPTION
WHEN OTHERS THEN
BEGIN
err_code := SQLCODE;
err_msg := substr(SQLERRM, 1, 200);
INSERT INTO ZERREURS (nom, err_code, err_msg) values ('TABLE1', err_code, substr( err_msg, 1, 200));
commit;
END;
END;
/
Select 'After Insert' , to_char(sysdate,'DD/MM/YYYY HH24:MI:SS') from dual ;
spool off ;
exit |
Partager