Missing last "/" in script files

[thillson]

We are using version 5.1.

We have scripts that create oracle objects seperated by "/" characters. The last slash appears to be removed whenever we perform a save within plsql developer. Is this a known problem or are we doing something wrong?

An example that illustrates the problem:
I create the following file in plsql developer.
CREATE TABLE abc( col1 VARCHAR2(40) )
/
CREATE INDEX abc_x1 ON abc( col1)
/

I save it as a file, and re-open in the tool. It then seperates into different tabs. If I change something and save again the file no longer contains the last slash.

Any ideas?

Thanks,
Tom Hillson

 

[Marco Kalter]

My guess is that you are using a Program Window to edit this file. The Program Window should only be used for PL/SQL Program Units like Packages, Procedures, Triggers, and so on.

For SQL scripts with multiple DDL statements like this you should use the Command Window.