Oracle-L: RE: oracle locking question

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 15 Jan 2003 10:23:50 -0800
Message-ID: <F001.00530737.20030115102350@fatcity.com>

John - What SQL query was used to select these rows. Was it SELECT FOR UPDATE? Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, January 15, 2003 10:29 AM To: Multiple recipients of list ORACLE-L

> 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

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 - 12:23:50 CST