*****time stamp on same table:pl/sql****

Hi

I have a table testtable

name     vc2(10)
age      number
usr_id   number
u_tm     date

i want a trigger so that for any insert or update

usr_id will get userid from user_users
and u_tm will get current timestamp;

the trigger is giving an error.

create or replace trigger ins_tm_uid

       AFTER  INSERT OR UPDATE  ON testtable
       FOR EACH ROW


----

       declare
       		time_now    date;
       		curr_uid   user_users.user_id%type;


----

       begin
 	     time_now := SYSDATE;


----

             select username into curr_uid from user_users;
            if inserting then
              insert into testtable (usr_id,u_tm)  values
(curr_uid,time_now)
             where name=:new.name;
            end if;


----

      end;

/

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 24 2000 - 00:00:00 CST