Auto-select intermittently gives "ORA-00900: invalid SQL statement"

[WexSoft]

Hi Folks

This issue has been there for a long time, and is still there in the latest version (10.0.2.1697).

I use a SQL text file to store all the SQL I execute for a particular customer, on all the projects I work on for them. Over time this text file has grown to be quite large (now at over 31000 lines). The auto select feature normally works quite well, but every now and again when I add a new select at the end of the file and try to execute using auto select, PSD gives "ORA_00900: invalid SQL statement" because it starts the selection at the second character (i.e. misses out the S at the beginning of SELECT). If I highlight the full statement with the mouse and execute it works fine. Also, if I move the select statement up a few lines in the text file (so it's not the last statement in the file), the auto select works fine. I will email 2 screen shots to the support email address to show the problem.

Best regards

Billy

 

[Marco Kalter]

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

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

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