Tabbed PL/SQL Files, like Package or Trigger: final slash after end; removed

[Bernhard S]

In my trigger file *.trg I have several tabs with different triggers. When editing and storing with the new beta version, I got the last slash after the END; removed! This causes a lot of errors when deploying like that via SQL*Plus.

So instead of the correct:

END;
/

it ends now wrongly like:

END;

The triggers before the last one are fine and correctly ended with slash.
Why are those slashes never shown in PL/SQL Developer?
It might be easier if you see there as well what gets actually stored.

The behaviour is the same for a package file .*pck consisting of separate tab for spec and body: The body gets the final slash removed as well!

So probably this is a problem for all tabbed files containing PL/SQL Code which is supposed to always end with

END;
/

 

[Bernhard S]

This problem is currently a show stopper for me preventing me from using the beta version for real development. So hope this gets fixed quickly.

 

[Marco Kalter]

This works fine for me. Can you send me an example file?

 

[Stew Stryker]

Bernhard,

I read there's a new setting for this. Is there any chance you have it turned off??? Sorry, I had to ask.

Stew

p.s. I don't know why the img tag isn't working above, but it's a screenshot of the Preferences window.

 

[Bernhard S]

Thank you Stew,

yes that was in fact the case. I was just wondering why it only reproduced on one installation, but not on the other and they differ in exactly this setting.

I guess the behaviour is still wrong then for the objects which are not in the last tab, because you always get a slash there currently. Shouldn't you consistently "have slash"/"no slash" then after the "END;" of each PL/SQL program depending on the setting? What is the idea anyway for storing with "no slash"? It makes that part undeployable via SQL*Plus. So what is point of having this option?

 

[Stew Stryker]

Berny,

The Release Notes say 'A "Save with trailing slash" preference has been added.'

So it seems like it's working correctly if it's keeping the slashes on the various tabs. The way I read that feature, it's just the end-of-file slash that would get removed.

Have a good weekend all!