Having a serious problem with auto commit. when I open a SQL session and execute some dml statemets and exits from SQL sessions, the statements are getting committed. Is there any way by which i can force sql to rollback instead of getting committed.
But set AUTOCOMMIT off is to indicate whether to commit automatically after each DML Statement. Is that right? My problem here is, after I run some DML statements and just exit from the SQL session, that is commiting all the statements that were executed earlier.
I don't think this parameter is set at the INIT<sid>.ora file. Anyhow, AUTOCOMMIT is either to auto commit soon after the DML statement or wait for either a explicit commit from the client. Isn't that right??