Re: ORA-00917 error while inserting data

Just a wild guess, but try using " instead of '

Insert into test values ("Oracle Test...","Test");

See if it helps....

Martin Lilienthal <martin.lilienthal_at_gmx.de> wrote:

>I am new to Oracle and have installed Oracle8 on a Linux system (SuSE
>6.0, glibc 2.0, Kernel 2.2 Final) and I always get while inserting data
>into a table the following error:
>CREATE TABLE test (col1 varchar(60), col2 varchar(60));
>statement processed
>
>INSERT INTO test VALUES ('Oracle test ...', 'test');
> *
>ORA-00917 missing comma
>
>I tried this too:
>
>INSERT INTO test (col1, col2) VALUES ('test', 'test');
>
>but I got the same error.
> I reinstalled Oracle but the problem still exists.
>
>Please help, I need to finish my project the next days.
>
>Thanks
>
>-- Martin Lilienthal
>
>

To reply please remove the 'nospam' part of the address Received on Thu Feb 18 1999 - 13:37:29 CST