Autocommit after insert problem (merged) [message #384274] |
Tue, 03 February 2009 01:47  |
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 #384444 is a reply to message #384277] |
Tue, 03 February 2009 20:35  |
 |
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
|
|
|