Question Re: Try/catch does not work together with spatial data? in Technology Q&A

Try/catch does not work together with spatial data?

Former Member — Tue, 17 Feb 2015 06:58:06 GMT

Hello,

I have an insert inside a try block and when I try to set a NOT NULL Column to NULL I end up in the catch but

SELECT SQLCODE, ERRORMSG() INTO v_sqlcode, v_errormsg

end up with

v_sqlcode= 0 v_errormsg = NULL

Is this a correct behaviour or should it work?

Re: Try/catch does not work together with spatial data?

Former Member — Tue, 17 Feb 2015 11:15:33 GMT

Is the SELECT statement the first statement executed in the error handler?

Try using ERROR_SQLCODE and ERROR_MESSAGE builtin functions - those should report the error information anywhere in the handler, not just in the first statement.