Well, you say it's a LOGON trigger but the code you posted says it's a
LOGOFF trigger. Which is it ?
mvg/regards
Jo
Onkar N Tiwary
<onkarnath.tiwary@ To:
oracle-l@xxxxxxxxxxxxx
gmail.com> cc:
Sent by: Subject: Trigger not
firing!!!!!!!!!!(URGENT)
oracle-l-bounce@fr
eelists.org
06/09/2005 12:46
Please respond to
onkarnath.tiwary
hi all,
I have created one trigger on LOGON event which is storing the ip of the
machine making the connection,current date n time and oracle username in a
table with the following structure:
16:15:31 SQL log@TEST35> desc info
Name Null? Type
----------------------------------------- --------
----------------------------
IP NOT NULL VARCHAR2(40)
LOG_DATE NOT NULL DATE
ORAUSER NOT NULL VARCHAR2(20)
, but its not working. Dont know where is the error????
Can anyone plz. suggest me how to do this?????
CREATE OR REPLACE TRIGGER INFO
BEFORE LOGOFF
ON DATABASE
begin
insert into info
values(ora_client_ip_address,to_char(sysdate,'dd-mm-yyyy:HH:MI:SS'),ora_login_user);
end;
--
Thanks & Regards,
T. Onkar Nath
Ph : +91-9826728111(Cell)
to_onkar@xxxxxxxxx
onkarnath.tiwary@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
