Home » SQL & PL/SQL » 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: 373
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.

Report message to a moderator

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: 21765
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/)

Report message to a moderator

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: 9007
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.

Report message to a moderator

Previous Topic: error when passing values to the query
Next Topic: PL/SQL Developer settings FAQ
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 09 13:06:55 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.