This content has been marked as final. Show 1 reply
The Tools > Preferences > Database > Advanced > Autocommit checkbox only applies to the worksheet, not to execution from the code editor. If you have the log open (main toolbar: View > Log), you will see the following there when you run from the code editor:
It always opens a new connection and always commits before closing it, so it works as designed.
Connecting to the database <name> Process exited. Disconnecting from the database <name>
If you want to test a procedure and still be able to rollback with auto-commit off, then do something like this in the worksheet...
execute <proc_name>(<params1>, ...); select <whatever to verify the procedure's actions> rollback;
SQL Developer Team