Re: update multiple rows continue past exceptions
From: Thomas Kellerer <OTPXDAJCSJVU_at_spammotel.com>
Date: Sun, 13 Dec 2009 21:56:51 +0100
Message-ID: <7ol2o4F3quho0U1_at_mid.individual.net>
Kenneth Koenraadt wrote on 13.12.2009 21:14:
> That's interesting : The online doc clearly states that UPDATE works
> just as INSERT's regarding error logging..however, I have this simple
> test case, which works with INSERT's, but not UPDATE's. The OP wanted
> just that, so it may not work for him. Any thoughts ?
Date: Sun, 13 Dec 2009 21:56:51 +0100
Message-ID: <7ol2o4F3quho0U1_at_mid.individual.net>
Kenneth Koenraadt wrote on 13.12.2009 21:14:
> That's interesting : The online doc clearly states that UPDATE works
> just as INSERT's regarding error logging..however, I have this simple
> test case, which works with INSERT's, but not UPDATE's. The OP wanted
> just that, so it may not work for him. Any thoughts ?
That's in fact documented:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9014.htm#BGBEIACB
"The following conditions cause the statement to fail and roll back without invoking the error logging capability:"
[...]
- Any update operation UPDATE or MERGE that raises a unique constraint or index violation).
I didn't see that either the first time...
Thomas Received on Sun Dec 13 2009 - 14:56:51 CST