Ora-00936 Missing Expression

[rajeshgooner]

I am trying to insert records using toad into an oracle 9i database.

The table definition is as follows:

Name: Answer

id - Number(19) not nullable
question_id - number (19) not nullable
respondent_id - number (19) not nullable
survey_id - number(19) not nullable
scalar - number (10) nullable
multiple_choice_option_id - number (19) nullable
free_text - varchar2(255) nullable

The insert statement is:

insert into answer values (355,233,356,208,263,' ',);

This keeps on bringing up missing expression error. I've checked and there are no referential errors or key violations as all required fields have valid ids in their source tables. It's probably a very silly solution but is pushing me towards punching this flat screen......

 

[dbomrrsm]

insert into answer values (355,233,356,208,263,' ',' ');

if you want spaces in the last two columns.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[rajeshgooner]

Thanks but as there all but one of the fields are numerical, how can I enter a space. I tried your statement and it came up with the expected invalid number error.

 

[sem]

insert into answer values (355,233,356,208,263,null, null);

Regards, Dima

http://seminihin.narod.ru