1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
CREATE TRIGGER erreur_ora
AFTER INSERT on alert_log FOR EACH ROW
vSender VARCHAR2(30):='admin@iutinfo.fr';
vTo VARCHAR2(30):='test@gmail.com';
vSubj VARCHAR2(50):='Message ORA- détécté';
vMType VARCHAR2(30):='text/plain; charset=us-ascii';
BEGIN
IF new.LINE LIKE 'ORA-%' THEN
INSERT INTO event_log (insert_date, status, error_message, line_error_id) VALUES (sysdate, 'non resolu', new.LINE, new.LINE_ID);
utl_mail.send(vSender, vTo, NULL,NULL, vSubj, new.LINE, vMType, NULL);
END IF
COMMIT;
END; |
Partager