Re: Re: RE: How to prevent oracle from committing a transaction?

Bastards. You are totally right. I have tested and RTFM'd but the later doesn't specify when the change occurred. Should read release notes more often. Anybody has an idea about when it happened? 6.0.32 ? Please comfort me : exiting from a Pro*C program without calling EXEC SQL COMMIT|ROLLBACK WORK RELEASE (I hope it's not obsolete syntax, I have not used Proc*C for years) still does a rollback, does it ?

Stephane Faroult
Oriole Corporation

>Yeah, that's what I was going to suggest. QUIT used to do an exit without
>a commit, but now it commits it just like EXIT does. I wonder why they
>changed that? Now they are just synonyms of one another.
>
>Diana Duncan
>TITAN Technology Partners
>One Copley Parkway, Ste 540
>Morrisville, NC 27560
>VM: 919.466.7337 x 316
>F: 919.466.7427
>E: Diana_Duncan_at_ttpartners.com
>
>
>
>
> sfaroult_at_orio
>
> le.com To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
> Sent by: cc:
>
> root_at_fatcity. Fax to:
>
> com Subject: Re: RE: How to prevent oracle
>from committing a transaction?
>
>
>
>
> 06/05/2001
>
> 05:40 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
>Alternatively, you can also use QUIT.
>
>Stephane Faroult
>
>
>>What you're seeing is an implicit commit !To prevent it - before exiting
>the
>>session , issue ROLLBACK; & then EXIT
>>
>>vikas
>>
>>-----Original Message-----
>>Sent: Tuesday, June 05, 2001 12:30 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Dear DBA Gurus,
>>
>> Can you tell me how to prevent oracle from committing a
>transaction
>>unless
>>I explicitly commit it. I have observed that when I insert a record into
>a
>>table and type exit from the sql prompt without commiting the transaction
>>and again open a new sqlplus session and select from that particular table
>>the record is inserted. How do I prevent oracle from inserting into a
>table
>>unless I explicitly specify commit? Please note that I have set my
>sqlplus
>>session as autocommit off. I tried with alter table <tablename> nologging
>>but it didn't do what I wanted. Can anybody help me in this regard?
>>
>>TIA and Regards,
>>
>>Ranganath
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Ranganath K
>> INET: ranganathk_at_subexgroup.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: Vikas Kawatra
>> INET: VKawatra_at_innoventry.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).
>>
>
>
>--
>Diese E-Mail wurde mit http://de.mail-inspector.de verschickt
>Mail Inspector ist ein kostenloser Service von http://www.is-fun.net
>
>Der Absender dieser E-Mail hatte die IP: 195.25.229.12
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: sfaroult_at_oriole.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:
> INET: Diana_Duncan_at_ttpartners.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).
>

--
Diese E-Mail wurde mit http://de.mail-inspector.de verschickt
Mail Inspector ist ein kostenloser Service von http://www.is-fun.net

Der Absender dieser E-Mail hatte die IP: 195.25.229.12

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: sfaroult_at_oriole.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).