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
prepek2000
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
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?

Regards
Michel

[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: 2103
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.

Kevin

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


Current Time: Fri Feb 14 08:23:55 CST 2025