i am trying to write asterisk's cdr into Oracle Database 11g Release 22.214.171.124.0 - 64bit Production.
sqlplus and isql works fine, but when * writes cdr, it gives an error.
i've enabled odbc tracing and have received that:
Statement = 0x46fb0d0
SQL = [INSERT INTO intercdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,a...][length = 224 (SQL_NTS)]
DIAG [HYC00] [Oracle][ODBC][Ora]Optional feature not implemented.
i've found, what does it mean:
The combination of the current settings of the SQL_ATTR_CONCURRENCY and SQL_ATTR_CURSOR_TYPE statement attributes was not supported by the driver or data source.
The SQL_ATTR_USE_BOOKMARKS statement attribute was set to SQL_UB_VARIABLE, and the SQL_ATTR_CURSOR_TYPE statement attribute was set to a cursor type for which the driver does not support bookmarks.
i understand, that i must set some attributes in odbc.ini, but i don't know, which attributes are necessary to change.