Program window removes slashes

[xcmichael]

I have scripst containing PL/SQL pachages (header and body).
At the end of these files there are some additional lines containing grants and synonyms.
Each of this statements is closed with a slash at the folloeing line.
After opening and editing the file in the program window the last slash is removed from the file.
Qur automatic deployment fails if there are slashes missing.
I found another posting which seems to be the same problem ( posting ).
At the end of the Posting I can find the comment "We'll fix it."
Is it already fixed? I'm using the version 9.0.1.1613 where the problem is still existing....

 

[Marco Kalter]

I don't think this is the same problem as the other topic you mentioned. We'll check it out, but the only workaround at the moment is to use a semi-colon instead of a slash.

 

[Ivan C.]

This problem still occurs in PL/SQL Developer 9.0.6.1665.

Our scripts are very similar to what's described above.
The statement(s) after package's body are included in a PL/SQL block, so the only statement termination option for us is a slash.

Here's an example of the original file:

create or replace package pkg_test as
  procedure p_test;
end pkg_test;
/
create or replace package body pkg_test as
  procedure p_test is begin null; end p_test;
end pkg_test;
/
begin
  -- statements that must be executed as a PL/SQL block (not SQL*Plus)
  p_some_other_procedure;
end;
/

Save the above code in a file, open it in a Program Window, then just press Ctrl+S (to save it). Now open the file in a text editor.
The last slash (at the bottom of the script) was removed.

This, when fixed, would be a very welcome improvement, as it becomes a big headache, when scripts fail due to a missing slash, and it wasn't developer's fault

 

[Ivan C.]

Any updates on this, Marco, or is this topic archived?

 

[Marco Kalter]

We are working on an enhancement for this in the next release.