OraFAQ Forum: Client Tools » SQLdeveloper Query Hangs

Home » Other » Client Tools » SQLdeveloper Query Hangs (SQLdeveloper Version 19.2.1.247) (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLdeveloper Query Hangs [message #687501]

Tue, 21 March 2023 10:58

wtolentino
Messages: 421
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.

Attachment: SQLdeveloperHangs_SQLPlusworksfine.JPG
(Size: 26.36KB, Downloaded 4970 times)

Report message to a moderator

Re: SQLdeveloper Query Hangs [message #687521 is a reply to message #687501]

Sun, 26 March 2023 15:15

Littlefoot
Messages: 21823
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

Barbara Boehmer
Messages: 9101
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:	problems with servers (tns:protocol adapter error)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 19:13:32 CST 2024