RE: How to prevent oracle from committing a transaction?

From: <MHately_at_etech-uk.com>
Date: Tue, 05 Jun 2001 03:16:12 -0700
Message-ID: <F001.0031BA70.20010605032532@fatcity.com>

Wow, you're right.

Let this be a warning to you all; this is what happens to your brain when you mess with DB2. Just say "no" kids.

)

Thanks,

Mike

Hi Mike,

I was also thinking so. But it doesn't do so. Setting autocommit off will
implicitly commit all your transactions for that session. For doing this I tried exit rollback as suggested by Marco, one of the list members.

Thanks and Regards,

Ranganath

Phone: (01670) 593900
Fax: (01670) 593909
Web Site: http://www.etech-uk.com

E-MAIL DISCLAIMER The information in this email is confidential and may be legally privileged.It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.

All information provided, including but not limited to, quotations, system specifications and suggestions concerning hardware/software (and services) configurations are strictly subject to our standard terms and conditions of business, copies of which are available on request.

--

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

Author:
INET: MHately_at_etech-uk.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). Received on Tue Jun 05 2001 - 05:16:12 CDT