Home » SQL & PL/SQL » SQL & PL/SQL » Autocommit after insert problem (merged)
Autocommit after insert problem (merged) [message #384274] Tue, 03 February 2009 01:47 Go to next message
Messages: 5
Registered: October 2008
Junior Member
Hi to all!

I have problem with DML statements, namely when i do insert system automatically do commit, and i have checked up with show all command and auto commit is off. What i need to do, so that my DML statement don't do auto commit?

thanks in advance!
Re: Autocommit after insert problem (merged) [message #384277 is a reply to message #384274] Tue, 03 February 2009 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65079
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In Oracle, there is NO autocommit.
Your client may autocommit.
Which one is it?
Are you sure there is an autocommit? How did you see it?


[Updated on: Tue, 03 February 2009 01:55]

Report message to a moderator

Re: Autocommit after insert problem (merged) [message #384444 is a reply to message #384277] Tue, 03 February 2009 20:35 Go to previous message
Kevin Meade
Messages: 2102
Registered: December 1999
Location: Connecticut USA
Senior Member
op said SHOW ALL which suggest he is in SQLPLUS. sqlplus has a

set autocommit on
set autocommit off

if autocommit is off in sqlplus then you are not commiting doing simple dml. What proof do you offer that this is so? Try doing an insert then doing a rollback then looking for the insert. This will prove if you have automagically commited.


Previous Topic: insert statement
Next Topic: Create table if it doesn't exist
Goto Forum:

Current Time: Thu Jul 20 19:43:04 CDT 2017

Total time taken to generate the page: 0.13225 seconds