Return
-
Title
Where is the Auto-Commit option set? -
Description
I am trying to switch on Auto-Commit can you advise me please where I can set this option.
-
Resolution
To set the Auto-Commit option in Toad:
1. Select View | Options | Oracle | General.
2. Enable the 'Commit automatically after every statement' option. If this is checked then Auto-Commit is on, if it is not checked then Auto-Commit has been turned off.
3. Click OK to Apply the changes.
4. Exit Toad.
5. Restart Toad.