oraclequery error

[lynn_sai]

Hi,
I have a line:
insert into table(id,....)
values seq.nextval,....) in my oraclequery component.
I keep getting error ORA-00917: missing comma, points at .nextval ......... but I don't see anything wrong with that sql statement........Please help..

Thanks.

 

[AndreyB]

Guess you should declare :seq variable as otSubst and assign it 'you_seq_name.nextval' value.