I have done this by using the sqlplus task from Incanto (
http://incanto.sourceforge.net/usage-sqlplus.html) with failonerror=true and
the statement WHENEVER SQLERROR EXIT FAILURE ROLLBACK at the top of the SQL
scripts being run. This will cause any ORA error to halt sqlplus, thus
failing the Ant
I also crossed this road, and I ended up using Jakarta Jelly to do this.
It gives me specific Oracle errors, and it allows me to write more of a
script, with reusable values and methods.
> -Original Message-
> From: Pankaj Arora01 [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 02, 2007