SQL command not properly ended...

[aidenf]

Hi,

I am new to PL/SQL Developer. I think I have a simple question that many of you can help me with. We use PowerDesigner for data modeling and the SQL script that it generated uses the forward slash symbol '/' for statement execution. Unlike SQL*Plus, it seems like PL/SQL Developer does not support such symbol for statement execution. We do not want to modify the script generated by PowerDesigner. The error message that we are getting from PL/SQL Developer is ORA-00933 SQL command not properly ended.

Example of the script:

drop indes TEST.FKxxx
/

Thanks!

Aiden Fung

 

[aotte]

Hi Aiden,

Try the Command Window instead of the SQL window.

The SQL Window gives you single execution with grid results.
The Command Window gives you SQL*Plus clone capabilities. See manual as to which commands are supported.

 

[aidenf]

Thanks!!! That works!