Oracle Developer Tools for VS Code: How to configure auto-commit on each CTRL+E command?

Marcelo F. Ochoa

Hi:

  I am testing Oracle Developer Tools for VS Code on Linux + XE.

  On each command submitted from the Editor pane by selecting the text and press CTRL+E the command is executed and automatically commit on the DB side.

  How can I change auto-commit property on the connection setting?

  Thanks in advance, Marcelo.

Christian.Shay -Oracle

Thanks for the suggestion, Marcelo. We are going to do our best to get this into the July update. Stay tuned!

Christian.Shay -Oracle

Hi Marcelo,

This feature/fix is now available in the new 19.3.3 version. Please try it out and let me know what you think.

• When executing multiple SQL statements (for example, running a script), auto commit automatically commits work after each statement. If auto commit is disabled, an explicit COMMIT or ROLLBACK statement can be used to control the behavior
• In your SQL file, enter SET AUTOCOMMIT OFF or SET AUTOCOMMIT ON and then right click and select Execute SQL from the menu. This autocommit setting will be in effect for the life of your connection and will override the default extension setting.
• To set the default for all SQL files opened with this extension, Press F1 to open the Command Palette and enter Preferences: Open Settings (UI) command
• Expand the Extensions node and select Oracle Developer Tools for VS Code Configuration.
• Check the SQLPlus:Auto Commit checkbox to enable auto commit and uncheck it to disable it

User_WP7OZ

It would be great a key shortcut for commit or rollback!!