Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in assignment (SQL-22005) when using SQLParamOptions and SQL_C_CHAR

172604Nov 30 2006 — edited Dec 1 2006

I am getting "Error in assignment" when I use SQLParamOptions to bulk insert rows to a numeric data type (INTEGER, NUMERIC, REAL, etc) with a C type of SQL_C_CHAR. Based on the ODBC specs it should do the conversion for me, but TimesTen pukes. Oddly it works fine id you are only inserting one row, and it does work fine if you store the value as a SLONG and insert it into an INTEGER.

Basically, I am working on adding bulk insert into the DBD::TimesTen driver, VARCHAR's work fine.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 29 2006

Added on Nov 30 2006

#database-key-features, #timesten-in-memory-database

3 comments

2,819 views