Subject | RE: [ib-support] how do you debug triggers and SPs ? |
---|---|
Author | Ann W. Harrison |
Post date | 2002-02-18T16:33:25Z |
At 09:27 AM 2/15/2002 +0000, Richard Pendered wrote:
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
>Could you perform some kind of debugging with eventsUnfortunately, 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