[unixODBC-support] Error in BulkInsert

Nithesh Shetty knitheshshetty at yahoo.com
Thu Mar 1 16:07:26 GMT 2012


Hi,
 
We are facing problem while doing bulk insert using oracleinstant client 10.2.0.4 unixodbc 2.3.1 and oracle 10g.
 
Error message is as follows:
 
Handletype = 3 - OutputState = HY00 - Native Error Code = 1461 - ODBC Error Message = [Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG Column.
 
Here is quick snapshot of the api called
 
To Initialize recordset function call are:
OCIHandleAlloc
SQLAllocHandle
SQLSetStmtAttr 
 
The required statement attribute is set using
 
SQLSetStmtAttr = SQL_ATTR_PARAM_STATUS_PTR
SQLSetStmtAttr = SQL_ATTR_PARAMS_PROCESSED_PTR
 
SQLPrepare
 
SQLDesribeParam
 
row wise binding is done using 
SQLBindParameter
 
AutoCommit is set false
SQLSetConnectAttr  = SQL_ATTR_AUTOCOMMIT
 
SQLSetStmtAttr    = SQL_ATTR_PARAMSET_SIZE
 
SQLExecute
 
to Commit transaction  SQLEndTran api is called.
 
Data insert is valid but when execute is called it fails with the above error.
 
Regards,
 
Nithesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20120301/b2f85fef/attachment.html>


More information about the unixODBC-support mailing list