I get ORA-932 using ODBC to add a row to a table when the table has a specific configuration.

My company makes an application that uses Oracle Database through a Windows C++ ODBC connection. A customer is getting this error when he tries to add an item: ORA-00932: inconsistent datatypes: expected NUMBER got CLOB

I can reproduce this on Oracle 10.2.0.1 and 10.2.0.4.

I have reproduced this in a sample C++ application, and simplified it as much as possible. The table definition is a bit long but not overly so:

create table test1 ( 

TS_ID                                              NUMBER(11) not null, 

TS_ACTIVEINACTIVE                                  NUMBER(11), 

TS_PROJECTID                                       NUMBER(11), 

TS_ISSUETYPE                                       NUMBER(11), 

TS_STATE                                           NUMBER(11), 

TS_OWNER                                           NUMBER(11), 

TS_SUBMITTER                                       NUMBER(11), 

TS_LASTMODIFIER                                    NUMBER(11), 

TS_LASTSTATECHANGER                                NUMBER(11),