Page 1 of 1

Call SP from trigger

Posted: 07.03.2008, 22:55
by akli_agha
Is it possible to call a stored proc from trigger ?
An example ???


I'm using FB 2.0 and zeos 6.6.2


Thanks.

Posted: 10.03.2008, 22:01
by RayMarron
Yes, I believe you can using the EXECUTE PROCEDURE ... [RETURNING_VALUES ...] syntax. However, since that is a Firebird question rather than a Zeos question, I would suggest you ask on a Firebird-specific site/forum for a complete answer and example.