Cannot "Insert" into dblinked table with new version 7.0.0.1050

[YoYoPa]

I can select from linked table and get results no problem. But when I try to insert to it I get ORA-00900 Invalid SQL Statement. However if I take this same SQL and copy it into Oracle SQL Plus and execute it, it works. This is using the same login id as used with PSD. Previous versin of PSD I had no problem although it's been a little while since I ran this same sort of thing.

When I look up the cause for ORA-00900 several sites say the following:
"The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed."

I searched PSD preferences etc. but could not find any reference to the "Procedural Option"

Any help would be appreciated.

Thanks

 

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