Re: Trigger HELP
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-958161-2003.04.24-08.17.42--gcdod-oracle#[email protected]> |
For some help you will need to specify some more details. What is the exact error message ? What does the table look like ? (is the column long enough) .. X ------------------------ "Oracle" <[email protected]> wrote: ------------------------ >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].