ORA-0900: invalid sql statement

[Drewb]

I create numerous queries in a sql window throughout the day. Each one is terminated with a ';'. Sometimes I can just put my cursor in a particular query and process with no problem. Other times I get a 'ORA-0900: invalid sql statement', unless I highlight the query. Not a major deal, but it's easier when I don't have to highlight every time.

TIA

Drew

 

[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.

 

[Drewb]

Hi Marco -

Attached the debug.txt file to an email and sent to support@allaroundautomations.com

Thx.

Drew