MySQL Forums
Forum List  »  Triggers

Re: Accessing NEW.x values from within stored procedures called by triggers
Posted by: Roland Bouman
Date: November 02, 2005 08:12AM

Did you try it like this:

declare new_col int;
set new_col := new.col
call check_data(new_col);
set new.col := new_col;

(where
procedure check_data is like (INOUT new_col int)
)
?

(In my experience, parameters of sp's are not limited to @ variables, you can use 'normal' sp variables.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Accessing NEW.x values from within stored procedures called by triggers
2118
November 02, 2005 08:12AM


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.