Re: Trigger HELP

If you have defined date_created as a date then you should be able to set

      :new.date_created = sysdate;

Regards
Chris Farmer



                                                                                                             
                      "leonard Anukam"                                                                       
                      <leonardanukam@ho        To:       "Oracle" <[email protected]>                      
                      tmail.com>               cc:                                                           
                                               Subject:  [oracle] Trigger HELP                               
                      23/04/2003 20:40                                                                       
                      Please respond to                                                                      
                      "Oracle"                                                                               
                                                                                                             
                                                                                                             




I have a table in which I will want a date and time to be stored when a
visitor visits my site and fills the form. I have a trigger that
automatically inserts the date, but the time.
http://www.netikka.net/leo
Here is my code

create or replace trigger visitor_date_created
before insert on visitors
for each row
begin
:new.date_created := to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS');
end;

But this returns an error.

Please give you solution

thanks

Leonard

---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.






---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].