I recently upgraded from 11.x to 12.1 and since then the program has been misbehaving after running a particular stored procedure in the SQL window. The procedure adds and subtracts from certain tables, inserts, updates, deletes etc.
After executing the the proc, the program becomes slow to respond, taking several seconds to respond to mouse clicks so I can commit the session, though it does report commit was successful. Throughout, the mouse icon is an hour glass. Quitting the program prompts “Cancel execution and close tab?” yet does not quit when I choose yes,
This appears to me to be a bug with 12.1 as it worked immediately prior to the upgrade. Is there any way to debug this issue, or are there any updates to the program available?