Home » Other » Client Tools » SQLdeveloper Query Hangs (SQLdeveloper Version 19.2.1.247)  () 1 Vote
SQLdeveloper Query Hangs [message #687501] Tue, 21 March 2023 10:58 Go to next message
wtolentino
Messages: 390
Registered: March 2005
Senior Member
SQLdeveloper Version 19.2.1.247
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.17.0.0.0
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.


/forum/fa/14700/0/

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
Littlefoot
Messages: 21802
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: 9077
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: Sat Mar 02 23:35:00 CST 2024