Try/catch does not work together with spatial data?

[Former Member]

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?

[Former Member]

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.