Unique constraint
I am running Oracle 10g under Appworx 7 and am running a SQL script that returns a ORA-0001 Unique Constraint error. The sql script is exiting but I am not able to track the error code. I have coded whenever sqlerror exit 9 and whenever oserror exit 25 in the SQL script. Appworx returns a 0 exit code as if the SQL script completed successfully. Is there another code that I can check to exit this script and have Appworx pick it up?
0