RE: [firebird-support] Recording Error Trapped in Stored Procedure

[Marius Labuschagne]

Hi,

I have used SQLSTATE to record the error state.  I will then just go find
the message for the SQLState on the internet.

Regards
Marius

Re: [firebird-support] Recording Error Trapped in Stored Procedure

[Thomas Steinmaurer]

Marius,

 I have used SQLSTATE to record the error state.  I will then just go find
 the message for the SQLState on the internet.

If you want to be sure that your log entry gets inserted, even in case 
your client transaction gets rolled back, you have to look into wrapping 
the INSERT INTO statement into an autonomous transaction.


-- 
With regards,
Thomas Steinmaurer
http://www.upscene.com/