No query results after changing connection, and break button doesn't work

[Rens]

Hi, I have 2 issues while using PLSQL Developer 15.

- When I execute a simple SQL statement is shows results.
- After changing to another connection, and execute the same query again, the query keeps executing en no results are shown.
1) I would expect to get results for the query after changing connection.

- When I use the break button (Shift+esc) nothing happens.
- When I use the "close tab" button of the sql window I get the option to terminate the running query.
- After opening a new SQL window en enter the same query to exeute, I do get results.
2) Why can't I use the break button to stop executing the query?

I Attached the debug.sql file.
View attachment Debug.txt

 

[Marco Kalter]

In the log file I can indeed see a "select * from tbs_owner.brs_bericht" that hangs. Can you try the same scenario with a "select * from dual"?

The break button probably does not work due to the the same cause.

 

[Rens]

I can't reproduce the issue with "select * from dual"
But I don't think it's the specific query on brs_bericht. When I try another query on another database:

- I get results, then switch connection
- then execute the same query again
- it keeps executing
- then I close the window and terminate
- open the same query again and execute it
> I get results immediately.

 

[Marco Kalter]

Can you send me an export of a table for which this occurs, and also let me know your database version. This way we can try to reproduce the issue.