Change login information

[TMoore]

Hi guys

I put this in AfterConnect.sql :

BEGIN
dbms_application_info.set_module(module_name => 'my_progs',action_name => 'none');
END;

I works fine, but when I fire SQL Window it did not use AfterConnect.sql.

How to change it, I know I can write this same statmement in SQL Window.

cheers

 

[Marco Kalter]

Did you add a trailing slash like this?

BEGIN
  dbms_application_info.set_module(module_name => 'my_progs',action_name => 'none');
END;
/

 

[TMoore]

Marco it works fine in session window, but
when I fire sql window and pass select sysdate from dual I see that in module I see pl/sql developer.

How pass dbms_application code automaticly via login.sql file?

 

[Marco Kalter]

You should not use login.sql. You will need to use the AfterConnect.sql script, which runs for all sessions.

 

[Karolski]

Hi Marco,

Your code works fine for SQL Window. But when I run the following sql: select module, action, client_info,action,program from v$session;
I can still see Main Session with Module=PL/SQL Developer. Is there any possibiliy to change this name as well?

Many thanks.
Regards,

 

[Marco Kalter]

Can you modify the shortcut and add the NoAppInfo parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" NoAppInfo

Now PL/SQL Developer will no longer set the application info, and will not override anything you have set yourself.

 

[Karolski]

It works!
Thanks a lot!