Re: Accessing NEW.x values from within stored procedures called by triggers

[Roland Bouman]

Hi Beat!

Glad that worked.

I prefer to put the logic in procedures too, and have the trigger call the procedure. It's just a habit. I can't really give a good reason as to why i prefer it, because you could make just as big a mess in the stored procedure that handles the trigger. I know I do ;-)

As for allowing SP's to refer to NEW and OLD values directly, well, I don't think that that's desireable at all.
It definitely would be nice to be able to pass NEW values to INOUT parameters though. (I did not have time to recheck, but I thought it was not a problem to pass NEW or OLD values to IN procedure parameters in a CALL statement).

(By the way, I'm off topic here, but I like the improvement on xtabs you did. Good one!)