Data fetch issue thru PL/SQL developer

[rk68]

Hi,
We have been facing problem in Oracle while executing SQL queries from PL/SQL developer.
Even if a simple select query with around 8000 records, data is only fetched for around 2000 records and then it shows as "Executing...." but no more records are fetched. We have to terminate by closing the PL/SQL developer after some time.
If the same query is executed thru SQLPLUS, it executes.
Our DBA has been trying hard to sort the issues but all in vain.
What could be the reason as no changes were carried out on the server.

TIA,
Raj

 

[johnherman]

Is there some sort of default record retrieval limit (2000) for SQL Developer? Check the options within the client, perhaps a default is set to 2000. Check for an .INI or some kind of options file. Check the online support for PL/SQL Developer.

https://www.google.com/url?sa=t&rct...l-developer/&usg=AOvVaw1tPlgyiL7xv2l10Gic2z4q

Do you have any other clients such as TOAD? If so, does the query execute there?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[rk68]

Hi Johnherman,
Its nothing to do with the record retrieval limit on PL/SQL developer since we didn't make any changes in the settings.
Since all the users are facing this problem, I don;t think its related to the record retrieval limit.
Thanks for the reply.

TIA,
Raj

 

[johnherman]

Since the query executes to completion in SQL*Plus but not in SQL Developer, it is clearly a SQL Developer problem. Did you do any patches to Oracle? Can you get a trial copy of TOAD or some other developer tool to see if it happens there as well?

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity

 

[rk68]

Thanks Johnerman. We re-started our database server & its working find now