Compile Script packages

[Pierre Maas]

Is there a possibility that in a .pck file, before the "create and replace package/body", automatically a sql statement can be placed. Like: set define off.
I am also looking for a possibility to put at the end of the file sql statements automatically. Like: exit;

 

[ILoveOracle]

Hi,

You can use macros or template files (have a look into PL/SQL Developer's template subdirectory).

 

[Pierre Maas]

Hoi, thanks for the quick reply. Ok, with macros you can work around this. With templates, I changed one template and add the additional line. I want as default at the last line the "exit;". You see the this line show up when a new package has been choosen. When you compile this then an error pops up. In fact when i do a save of this file then this additional line has to be added at the end. This happens with the slash. In the template you see the slash but in the editor you don't seen it. If you open your script file with notepad and going to the end then you see the slash again. This kind of construction I am looking for.

 

[ILoveOracle]

I see. Well then I'm not sure that there is a solution in current version of PL/SQL Developer.

 

[ScottMattes]

It sounds like you are trying to get around a SQL Plus problem?

Maybe you could create a SQL script that does the 'set define off' and an 'exit' with a call to the script with the package code in it?