At the beginning of your sqlplus script you should add something similar
to the following.
whenever oserror exit failure rollback
whenever sqlerror exit failure rollback
These lines will cause sqlplus to set the exit code. If you don't want
to hardcode these lines in all of your sqlplus scripts, you can use
ant's redirector feature to prepend them at runtime.
-----Original Message-----
From: Henrik Skovhus Poulsen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 15, 2005 8:37 AM
To: user@ant.apache.org
Subject: Handling Exec errorcodes
Hi
I'm currently trying to call sqlplus from the exec task. But I kinda
need away to know if the command succedes or not.
I been using the resultproperty option to see if the return code is
different from when the command is a success and when its a failure. But
this is not the case.
Does anyone have an idea to how you can handle error messages when you
call the exec task??
Kind regards
TDC Kabel TV
Henrik Skovhus Poulsen
Strandlodsvej 30
0900 Copenhagen
P+ 45 32638129
E [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
