SQL*Plus (MOSC)

MOSC Banner

Unique constraint

edited Jun 15, 2009 8:00PM in SQL*Plus (MOSC) 1 commentAnswered
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? 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center