Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: V$SESSION
Can be done with a logon trigger which sets the program name in its body:
create or replace trigger session_trigger
after logon
on schema
declare
sys.dbms_application_info.set_module('<programname>');
Regards, Bernhard
"Pier Gaetano Novara" <pgaetano_at_csc.com> wrote in message
news:aoornp$rgt$1_at_lore.csc.com...
> I need to set the column Program Name of view V$SESSION, does someone know
> hot to do using an ODBC connection?
> Thanks and regards.
> Pier Gaetano Novara
>
>
Received on Fri Oct 18 2002 - 17:37:50 CDT