RE: oracle locking question

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Wed, 15 Jan 2003 08:44:04 -0800
Message-ID: <F001.005305C9.20030115084404@fatcity.com>

Yes ... because you are doing a transaction. Row count 0 is the result, but at that time transaction is still in uncommitted state. Please issue a commit or a rollback to complete the transaction ..

Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Wednesday, January 15, 2003 11: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: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Wed Jan 15 2003 - 10:44:04 CST