Re: Trigger not firing!!!!!!!!!!(URGENT)
- From: Yechiel Adar <adar76@xxxxxxxxxxxx>
- Date: Thu, 09 Jun 2005 15:59:07 +0200
In out system the trigger is defined with: pragma autonomous_transaction
and I do commit.
Anyway, problems with triggers appears in the alert log and in trace
files on the server.
(oracle 9.2.0.5 on windows 2000.)
Adar Yechiel
Rechovot, Israel
Onkar N Tiwary wrote:
>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;
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
