Delphi App to set Oracle Session Details

[Jeffrey Sadler]

Hi,

I notice when I run PL/SQL Developer and look at the session details for the database that I see the PL/SQL Developer app has an entry in the Module and Action field where as my delphi app does not. How is this done? Can this be done through your DOA components?

Thanks.

Jeff

 

[Jens Fudickar]

It could.

It's the oracle dbms_application_info-package.

As far as i know (no delphi open), there is a dbms_application_info class in the session object.

You can use the set_module, set_action and set_dbms_application_info procedures.

This is very usefull and i like to this by all programs.

Greetings
Jens

 

[Jeffrey Sadler]

So easy, thanks!

 

[Jens Fudickar]