MySQL Forums
Forum List  »  Triggers

How to Migrate Oracle Trigger to MySQL Trigger???? below is my oracle trigger code
Posted by: eswar kuruba
Date: March 19, 2014 04:23AM

create or replace TRIGGER TRIG_NM
BEFORE UPDATE OF C7_COLUMN ON XXXTABLE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
WHEN (NEW.C7_COLUMN=4)
DECLARE
tmpVar NUMBER;
BEGIN
IF :NEW.C7_COLUMN=4 THEN
:NEW.C5_COLUMN := :OLD.C7_COLUMN;
END IF;

EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END ;

Options: ReplyQuote


Subject
Views
Written By
Posted
How to Migrate Oracle Trigger to MySQL Trigger???? below is my oracle trigger code
2037
March 19, 2014 04:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.