Using Oracle SQLERR in Alteryx

martman

Hi All

Hope someone can help.

I have a procedure call in the pre sql statment of an input tool which works fine but I would like to use SQLERR to determine if it failed or not, but I am unsure as to how I would use SQLERR  or even if its possible.

Thanks

TrevorS

Hello @martman 
I was able to find these articles regarding the SQLERR function.
https://documentation.basis.com/BASISHelp/WebHelp/commands2/sqlerr_function.htm
https://docs.oracle.com/cd/B19306_01/appdev.102/b14261/sqlerrm_function.htm

From the docs.oracle.com link, the following is stated "You cannot use SQLERRM directly in a SQL statement."

Unfortunately, it doesn't look like the call you are trying to make is possible.

Thanks,
TrevorS