Saving test script files

[Albert Dondero]

When I save a test script, the following lines are added

Top of file
PL/SQL Developer Test script 3.0
124

Bottom of file
0
0

Is there a way to prevent it from writing those lines, or to have it write them as "comments" if the front-end needs them? The reason I am asking is that when I give the file to our DB team to run the script, they have to remove those lines to run it via their command line process.

Also, would it be possible to have a "/" written out at the end? We have a deployment process to keep many Development databases up to date, and we have to open the files in Notepad to update them after saving from PL/SQL Developer.

Not sure if I am just missing a setting somewhere.

 

[Albert Dondero]

When I save a test script, the following lines are added

Top of file
PL/SQL Developer Test script 3.0
124

Bottom of file
0
0

Is there a way to prevent it from writing those lines, or to have it write them as "comments" if the front-end needs them? The reason I am asking is that when I give the file to our DB team to run the script, they have to remove those lines to run it via their command line process.

Also, would it be possible to have a "/" written out at the end? We have a deployment process to keep many Development databases up to date, and we have to open the files in Notepad to update them after saving from PL/SQL Developer.

Not sure if I am just missing a setting somewhere.

Also, if those lines are not there for a test script, I cannot open it back up (Invalid "test script")

 

[Marco Kalter]

The Test Script file format includes information about the variables, so it cannot directly be executed in other tools. However, if you select "Save As" from the Test Window and select "SQL*Plus" for the "Save as type", the resulting SQL script can be executed in other tools like SQL*Plus. Note that this SQL script cannot be opened in the Test Window again, so you will also need to keep the .tst file.