AfterConnect.sql script change request

[Max Castagno]

Hi,
I've just a problem with AfterConnect.sql script.
I need to change the informations in V$Session table pertinent to MODULE, ACTION and CLIENT_INFO fields whenever a connection is made using PL/SQL Dev.
Now I've introduced this in AfterConnect.sql nd Login.sql scripts:

BEGIN

DBMS_APPLICATION_INFO.SET_MODULE('Module', 'Action');
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('Client Info');

END;
/

For the main connection (browser) and the Command Windos, this works fine. But when I open a SQL Window the script is still executed, so I saw the CLIENT_INFO information changed, but the MODULE and ACTION fields are overwritten by PL/SQL Dev itself with "PL/SQL Developer" and "SQL Window - New" strings.
The workaround is, immediatiatly after a new SQL window session is started, to execute the same block contained in AfterConnect.Sql script, but this is not so friendly....
Is it possible to had a configuration option that permits to disable the "SQL Window" override?

Thanks in advance

Max

 

[Marco Kalter]

I have added this to the list of enhancement requests.

Note that if you need to do this a lot, you can create a "Session Tool" (Tools > Configure Tools). You can add this tool to the menu, to the toolbar, and create a shortcut key for quick access. After opening a SQL Window, you can easily run it.

 

[Max Castagno]

Thanks Marco,
as usual You are very kindly.

Now I'll try to configure Yr solution.

Have a nice day.

Max