SQL result grid not displayed in SQL Windows

[Frank Re]

The result grid is not displayed.

I already tried version 15.0.1, 15.0.2, and 14.0.6 all as 64 bit
I also tried to uninstall and to delete all user (registry) settings different times, but unfortunately no change

EDIT: I get an error when I try single record view.

See screenshots

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the PL/SQL Developer 15 shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 15\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 15 directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer 15).

 

[Frank Re]

Attached you'll find the Debug.txt

I did the same as in the first message: Start program, Execute query (empty grid), change to single record view (exception)
View attachment Debug - Copy.txt

 

[Marco Kalter]

It seems that your Oracle 12.2 Client is not returning any data. Can you upgrade to a more recent Oracle Client version and try again?

 

[Frank Re]

Yeh, it's working now.
It seems that my oracle installation was broken. I removed all and I installed an instant client.
Thank you

 

[Peter H.]

I have the same problem. PLSQL Developer version 14, 64-bit, Oracle Instant Client 19.15 64-bit... on Windows 2008 Server 64-bit

I unzipped both things to a remote terminal server Windows 2008, configured everything as I was used to on various PCs for the past 10 years. Hacked the OCI.DLL paths, hacked the TNS_ADMIN var, hacked the plsqldev command line arguments, hacked the PATH variable,... The damn thing connects to a DB server, but it just (silently) returns no data.

After 5 hours of trying to set this up to make it work I finally gave up, downloaded+unzipped community edition DBeaver, pointed it to the Instant Client 19.15 JARs and... ... It just worked straight out of the box.

Sorry, PLSQL Developer, thanks to this client of mine you're out of game for the first time in the past 15 years. :-( You've been a truly great buddy to me, but it's time now...