Hi All,
plz tell me how to set autocommit off. I guess by default auto commit is ON. I want to do the same for at database level. Any parameter for that??
Thanks in advance...
Sandy
Printable View
Hi All,
plz tell me how to set autocommit off. I guess by default auto commit is ON. I want to do the same for at database level. Any parameter for that??
Thanks in advance...
Sandy
AFAIK it is a SQL*Plus command and there is no such parameter that can be set in init.ora file.
Sanjay
is there any way to set autocommit off??
From Sqlplus
SanjayCode:set autocommit off;
Hi Sanjay,
Thanks fo rthe fast reply...but my question was that can we do it at database level??
Moreover even I set Autocommit off at the session level and I exit the session without commit, but still I can see those values which I deleted but did not commit. Any solution??
Closing a user session does an explicit commit even if you set autocommit off. Similarly any DDL will also do an explicit commit. I don't think you can set autocommit off at database level.
HTH
Sanjay
Then what is use of SET AUTOCOMMIT OFF. In what condition it works??Quote:
Originally posted by SANJAY_G
Closing a user session does an explicit commit even if you set autocommit off. Similarly any DDL will also do an explicit commit.
HTH
Sanjay
When you set autocommit on. The DMLs are commited immedialy after the statement finishes. But in case of autocommit off it is not commited unless you issue commit or exit from sqlplus.
While exiting from Pro*C or JDBC you need to explicitly commit the transaction otherwise it will be rolled back.
Sanjay
Thanks Sanjay...it was a useful information...
Sandy