returning value from trigger
Is there a way to get the declared variable back from my trigger, so I can see witch ID is inserted.
this is an example of my trigger
TRIGGER test.trigger1
BEFORE INSERT
ON test.testtable
FOR EACH ROW
BEGIN
DECLARE NewID int;
SELECT MAX(ID)
FROM testtable
INTO NewID;
SET NEW.ID = NewID + 1;
END
Subject
Views
Written By
Posted
returning value from trigger
2763
February 06, 2009 07:32AM
2084
February 06, 2009 07:36AM
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.