RE: rollback after 0 rows affected

From: Paul Baumgartel <PaulB_at_instipro.com>
Date: Wed, 14 Feb 2001 11:42:20 -0800
Message-ID: <F001.002B46C5.20010214113100@fatcity.com>

Interesting...someone clever than I can probably construct a Zen view of the situation.

Absent that, however, COMMIT and ROLLBACK affect the permanence of changes caused by SQL statements. 0 rows deleted means nothing changed, so you could as well commit as roll back and the results should be identical. Test, though, to be sure!

Paul Baumgartel
InstiPro, Inc.
paul.baumgartel_at_instipro.com
212 813-0829 x103 (office)
917 549-4717 (mobile)

-----Original Message-----
Sent: Wednesday, February 14, 2001 1:37 PM To: Multiple recipients of list ORACLE-L

I'm using transactions, with a delete followed by an insert.

If the delete affects 0 rows, there is nothing to do.

Do I need to rollback the transaction to abandon it, or is everything the way it should after a delete that affected 0 rows?

Thanks!

Sincerely, Fred Frederik Lindberg, CTO, CheetahMail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Frederik Lindberg
INET: fred_at_cheetahmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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.com
--

Author: Paul Baumgartel
INET: PaulB_at_instipro.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------