Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$SESSION

Re: V$SESSION

From: Bernhard Jongejan <bj_at_born2run.tmfweb.nl>
Date: Sat, 19 Oct 2002 00:37:50 +0200
Message-ID: <aoq2g6$t13$1@reader13.wxs.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US