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: Roger Stapley <rstapley_at_uk.oracle.com>
Date: Tue, 14 Mar 2000 16:30:17 +0000
Message-ID: <38CE6919.8CCFA8F8@uk.oracle.com>


Try this instead :

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')
/

Worked OK for me.
Roger.

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.
Received on Tue Mar 14 2000 - 10:30:17 CST

Original text of this message

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