Hello,
did you try
DBMS_APPLICATION_INFO.SET_CLIENT_INFO('any information you like') ;
to set the session dependend client information? You can retrieve this later
via
V$SESSION.CLIENT_INFO
or via
DBMS_APPLICATION_INFO.READ_CLIENT_INFO(:g_client_info );
where :g_client_info is a bind variable.

For further ditiction you could use
DBMS_APPLICATION_INFO.SET_ACTION('action_name') ;
or
DBMS_APPLICATION_INFO.SET_MODULE('module_name','action_name') ;
and retrieve it via
V$SESSION.ACTION, V$SESSION.MODULE
or via
DBMS_APPLICATION_INFO.READ_MODULE(:g_module, :g_action);
---------------------------------------------------------
Landeshauptstadt M�nchen
Direktorium - AFID 3.3 - Oracle DBA
C.A. Merz


----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 18, 2003 11:25 PM
Subject: DBD::Oracle userenv('TERMINAL')


>
> Hello,
>
> I would like to set oracle's notion of my TERMINAL value.
>
> my $sql = "select userenv('TERMINAL') from dual";
> yields the tty:
> pts/10
>
> which is not particularly interesting.  can I override this setting
> to an application specified string?
>
> -j

Reply via email to