SQL Developer auto-commiting when debugging or running stored procedure.
I have a procedure stored in my database that I've opened using SQL Developer. When I open the procedure (from the Connections tab on the left pane), and execute the procedure using Run or Debug, I find that SQL Developer auto-commits the changes that happen within the procedure.
I am checking for results using a different session (different program entirely, actually), so I know it's actually a commit and not just uncommited data that I can see.
My autocommit box is unchecked in Tools > Preferences > Database > Advanced.
The procedure does NOT commit data when executed in a SQL Developer worksheet (copy and pasted the PL/SQL from the "Run" or "Debug" dialog box).
The procedure does NOT commit data when run from a program other than SQL Developer.
The procedure does NOT commit data if I manually alter the code from the "Run" or "Debug" dialog to issue a rollback after the procedure has completed.
This is SQL Developer 3.2.20.09.87 using Java Platform 1.6.0_37. I am running Windows 7 Professional 64 bit. The SQL Developer instance is a 32-bit version.
Any ideas?
Edited by: 929664 on Feb 11, 2013 5:57 PM