Re: Trigger with navicat

[Praneeth Kasam]

Please find the below trigger i have written using Navicat 8. Type in below format in Console(F6)


delimiter |
CREATE TRIGGER event_trg AFTER INSERT on integration
FOR EACH ROW
BEGIN
DECLARE event_id INT(50);
INSERT INTO eai_event (connector_id,object_key,object_name,object_verb,event_status,event_priority,event_time) VALUES ('CORConnector',NEW.staging_event_id,'CORINTEGRATION','Create',0,0,SYSDATE());
END; |