Just wondering...
When creating triggers, you're allowed to create conditions with the:
DECLARE condition-name CONDITION FOR SQLSTATE string-constatnt
However, you are not allowed to create handlers in the triggers themselves, but need to call a stored procedure.
So... what is the purpose of being able to declare conditions in triggers if you can't use them?
And secondly, if you call a stored proc, can you pass references to the old row / new row found in the trigger?
Thanks,
Ivan