alter session before package compilation

[vdragos]

Hi ,

I want to set some session variables before every package compilation.
for example :
ALTER SESSION SET PLSQL_CCFLAGS = 'my_var:TRUE';

how can i do that ?

thank you

 

[Marco Kalter]

This example can be done by clicking on the "Compiler Preferences" button on the Program Window toolbar and setting the flag, or by right-clicking on the object name and selecting "PL/SQL CCFlags".

 

[vdragos]

it seems I don't have this button in my 7.03 version.
is there any workaround for 7.03 ?

 

[Marco Kalter]

In 7.0.3 you can use the AfterConnect.sql file in the PL/SQL Developer installation directory. It will execute for each session created in PL/SQL Developer, not just the sessions used for compilation.