Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Odd oracle error (ORA-00984)
Change " to ' in your insert statement.
--
Have a nice day
Michel
<macleod72_at_my-deja.com> a écrit dans le message : 8almk6$sam$1_at_nnrp1.deja.com...
> 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:57:03 CST