Forum Stats

  • 3,768,499 Users
  • 2,252,800 Discussions
  • 7,874,600 Comments

Discussions

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,965 Employee
    edited Jun 27, 2019 4:00PM

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

  • 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: 7 Green Ribbon

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

    User_1NHL5
  • User_1NHL5
    User_1NHL5 Member Posts: 1 Green Ribbon
    edited Jun 4, 2021 8:25AM

    Hi,

    Do you have plans to have a keyboard shortcut for commit and rollback?

    Thanks