Odd oracle error (ORA-00984)

Hi all,

I created a table using this command:

CREATE TABLE EVENT_LOG(
machine_name varchar2(50),
event_date date,
event_text varchar2(50));

And I get "ORA-00984: column not allowed here: when I run:

INSERT INTO EVENT_LOG(machine_name,event_date,event_text) VALUES ("00001",TO_DATE("1/1/2000 12:34:56","MM/DD/YYYY HH24:MI:SS"),"did_stuff");

The infamous error asterisk appeared under the last comma.

Any ideas?

--Robert Amour
  goboilers1_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Mar 14 2000 - 09:41:59 CST