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

    Forum Stats

  • 3,715,958 Users
  • 2,242,917 Discussions
  • 7,845,703 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

Marcelo F. Ochoa
Marcelo F. Ochoa Member Posts: 21

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.

Answers

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,786 Employee
    edited June 2019

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

  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 1,786 Employee

    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
    User_WP7OZ Member Posts: 5

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

Sign In or Register to comment.