Home » Other » Client Tools » SQLdeveloper Query Hangs (SQLdeveloper Version  () 1 Vote
SQLdeveloper Query Hangs [message #687501] Tue, 21 March 2023 10:58 Go to next message
Messages: 404
Registered: March 2005
Senior Member
SQLdeveloper Version
Oracle Database 19c Enterprise Edition Release - Production Version
Oracle client oraclient19.dll

We had this database that we can connect to then when any query is run it hangs even a simple select sysdate from dual. However, when query is run on SQL*Plus connected to the same database it works fine. Any other tools also works fine but not to the SQLdeveloper.


Please advise. Thank you.

Re: SQLdeveloper Query Hangs [message #687521 is a reply to message #687501] Sun, 26 March 2023 15:15 Go to previous messageGo to next message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Upgrade? The last SQL Developer version is (currently) 22.2.1 (https://www.oracle.com/database/sqldeveloper/technologies/download/)
Re: SQLdeveloper Query Hangs [message #687522 is a reply to message #687521] Sun, 26 March 2023 17:45 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
I don't know if you are accustomed to using SQL*Developer or not. So, I don't know if you are aware of the differences between that and SQL*Plus. So, this may sound like a dumb question, but did you click on the little green triangle near the upper left corner of the worksheet to run the query? It doesn't just run if you hit the enter key like in SQL*Plus.
Previous Topic: error when passing values to the query
Next Topic: problems with servers (tns:protocol adapter error)
Goto Forum:

Current Time: Mon May 27 07:54:20 CDT 2024