Accessing environment variables

From: Tronak <jmoreno_at_hag.esIHATESPAM>
Date: Mon, 24 Jun 2002 13:20:41 +0200
Message-ID: <3d16ff9a$1_2@news.landsraad.net>

Hi all,

I would like a Oracle 8.3.4 trigger to read some environment values from the Citrix session which is accessing the database. Each Citrix session creates a CLIENTNAME variable which contains the connecting terminal name. I need this value to be inserted into an auditing table. Of course, this is performed by a trigger within Oracle server when user is trying to execute some "auditable" actions.

Could anyone help me?

Thank you in advance.

PD. Server: Oracle 8.3.4 on Windows 2000 SP2

       Citrix Server: Windows 2000 AS SP2
                            OracleInProcServer, Oracle Objects For Ole,

VB5SP3, Oracle 8.3.4 client.

--
Tronak el Kárpato
BAALPTEOR_at_terra.esIHATESPAM
(Remove IHATESPAM to send mails)

Received on Mon Jun 24 2002 - 06:20:41 CDT