I'm trying to insert a values in a table, that has 3 columns. But I'm getting "ora-00984 : column not allowed here" - error. I've taken a value in w_total = 20865000 and executing
insert into temp_latepos values ('USD',w_total,0) in VB 6.0. Please help me resolve this issue.
w_total is the figure got by various calculations and cannot be the same every time. USD is always constant and 0 is also constant.