RE: How to prevent oracle from committing a transaction?

From: Hillman, Alex <Alex.Hillman_at_usmint.treas.gov>
Date: Tue, 05 Jun 2001 09:20:47 -0700
Message-ID: <F001.0031C3D2.20010605085051@fatcity.com>

I did not try it but what if we have a trigger on logoff which will raise application error.

Alex Hillman

-----Original Message-----
Sent: Tuesday, June 05, 2001 5:05 AM
To: Multiple recipients of list ORACLE-L

Ranganath,

AFAIK, this can't be done. A normal exit has an implied commit. Perhaps someone else can suggest a way to do this programmatically.

HTH,

• Anita
  • Ranganath K <ranganathk_at_subexgroup.com> wrote:
    > 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).
    

    ---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.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: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

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 - 11:20:47 CDT