-support@yahoogroups.com
Subject: RE: [firebird-support] Transactions exception trapping
At 05:00 AM 11/08/2012, Rick Debay wrote:
FOR ... BEGIN
INSERT_PROCEDURE RETURNING VALUE
UPDATE TABLE WITH VALUE
WHEN ... BEGIN
LOG
END
END
If the insert procedure directly or indirectly causes
At 05:00 AM 11/08/2012, Rick Debay wrote:
FOR ... BEGIN
INSERT_PROCEDURE RETURNING VALUE
UPDATE TABLE WITH VALUE
WHEN ... BEGIN
LOG
END
END
If the insert procedure directly or indirectly causes an exception the
insert will be abandoned, the update will be skipped, and all data from
I have a table with before and after insert triggers. I also have a
stored procedure that loops, inserting rows in to the table. The last
statement in the loop is WHEN ANY to catch and log errors to an external
table and continue looping.
If an insert trigger throws an exception, will the
At 04:49 AM 10/08/2012, Rick Debay wrote:
I have a table with before and after insert triggers. I also have a
stored procedure that loops, inserting rows in to the table. The last
statement in the loop is WHEN ANY to catch and log errors to an external
table and continue looping.
If an insert