I'll jump into this conversation. I'm using PSD 14.0.4.1985. The About window says
OCI: version 12.1
DLL: c:\Oracle\instantclient_19_8\oci.dll
and I'm connected to an 11.2.0.4 DB
I'm using the 64 bit version of Instant Client
I have a query running and shortly after starting it, I clicked the red lightening bolt to break it and nothing happened. I've clicked it multiple times and nothing, also tried Session -> Break from the menu as well and nothing. PSD is still responsive, but the query continues to run. My Session Mode is "Multi session"
I used a Test window for the dbms_lock.sleep(seconds => 60); run against at 12.1 DB and it did not stop it. In fact, the Test window is still Executing.... and the time is up over 4 minutes now.
If I try to close the running tab and click Terminate, then that locks up PSD (which is probably to be expected).
I've successfully used Session Break before on prior versions of PSD against these two DBs when I was using the Instant Client 12.1. Is this a change in how Instant Client itself it working?