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: [EMAIL PROTECTED]
>
>
>
>
> sfaroult@orio
>
> le.com To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
> Sent by: cc:
>
> root@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: [EMAIL PROTECTED]
>>
>>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>>
>>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).