update multiple rows continue past exceptions
Date: Fri, 11 Dec 2009 14:41:03 -0800 (PST)
I need to update as many rows as possible. The issue is that one row that fails causes the entire transaction to fail.
How do I get around this? I'd like to complete all UPDATE rows that don't have the exception. The below doesn't seem to work.
I'm using Oracle 10g
Thanks a bunch!
UPDATE MYTAB SET request = REPLACE(request, '$tpsToModify', 'tpsToModify') WHERE request like '%$tpsToModify%'; EXCEPTION
when dup_val_on_index then
END; Received on Fri Dec 11 2009 - 16:41:03 CST