Aug 6 2012, 08:33 AM
is there try and catch in oracle query
do some update
if there was error go to here
Aug 6 2012, 08:51 AM
Boolean logic like this and the trapping of errors can be done in SQL*Plus, but you need to use PL/SQL, not SQL!
Please read: http://www.dba-oracle.com/t_ignoring_oracl...rs_in_plsql.htm
See this great reference for details:http://www.rampant-books.com/book_0501_easy_plsql.htm