Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Odd oracle error (ORA-00984)

Re: Odd oracle error (ORA-00984)

From: <macleod72_at_my-deja.com>
Date: Tue, 14 Mar 2000 15:57:03 GMT
Message-ID: <8alngd$t59$1@nnrp1.deja.com>


In article <8almk6$sam$1_at_nnrp1.deja.com>, macleod72_at_my-deja.com wrote:
> 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.
>

Sorry, I just noticed my double-quotes. Thanks nonetheless!

--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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US