Hi,

I am using the AFTER LOGON ON DATABASE Trigger in order to get the Users information.
But When I query the Table “client_history” from my LAPTOP. I didn’t get any information from the “client_history” table.

I like to say that, my client is on the Laptop and
the Server too.

However when I connect to Server via my PC (normal client server connection), I got the data via query the table.

I am using 8.1.7 version.
Could some one explain why I didn’t get the rows from laptop?

Regards

Chuck






CREATE OR REPLACE PROCEDURE Login

as

v_client varchar2(40);
v_ausid number;


BEGIN



select SYS_CONTEXT('USERENV', 'OS_USER') into v_client from dual;

select SYS_CONTEXT('USERENV','SESSIONID') into v_ausid from dual;


INSERT INTO client_history (hclient,hausid,)
VALUES
(v_client,v_ausid);

commit;

END Login;

/




CREATE OR REPLACE TRIGGER logintrig
AFTER LOGON ON DATABASE
CALL login

/