This discussion is archived
2 Replies Latest reply: Mar 12, 2012 3:10 AM by 922753 RSS

Error in Bulk(Batch) Insert

887243 Newbie
Currently Being Moderated
Hi,

We are facing problem while doing bulk (batch) insert using oracleinstant client 10.2.0.4 unixodbc 2.3.1 and oracle 10g on (Linux) RHEL 5.4 (x86-64).

Error message is as follows: Handletype = 3 - OutputState = HY000 - Native Error Code = 01461 - 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
QLAllocHandle
SQLSetStmtAttr

The required statement attribute is set using
SQLSetStmtAttr = SQL_ATTR_PARAM_STATUS_PTR
SQLSetStmtAttr = SQL_ATTR_PARAMS_PROCESSED_PTR
SQLPrepare
SQLDescribeParam

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points