Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Didn't get the information from the LAPTOP
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
Marjina
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
/
Received on Sat Apr 24 2004 - 10:50:21 CDT
![]() |
![]() |