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

Did you add a trailing slash like this?

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?

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

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,

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.

It works!
Thanks a lot!