> When doing an update that fails to update any rows, does a Rollback or a
> Commit need to be done at the end?
>
> We have a problem with some code where an update is attempted, but after
> the SQL command has run SQL%ROWCOUNT = 0 so no rows were updated. The
> program does not then perform a Commit or Rollback. This appears to be
> causing some locking problems, but how can any thing be locked if no rows
> were updated?
>
Platform is 8.1.7
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Dunn
INET: john.dunn_at_sefas.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jan 15 2003 - 10:28:59 CST
