Subject RE: [ib-support] how do you debug triggers and SPs ?
Author Ann W. Harrison
At 09:27 AM 2/15/2002 +0000, Richard Pendered wrote:
>Could you perform some kind of debugging with events


Unfortunately, no. Events aren't fired until a transaction
commits and there's no way to commit a transaction during
the execution of a stored procedure. My suggestion is to
keep stored procedures short by breaking complex operations
into small steps implemented as separate procedures.

Regards,


Ann