i am trying to write asterisk's cdr into Oracle Database 11g Release 220.127.116.11.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.
now my odbc.ini looks so:
Driver = ora10odbc
DSN = ora5
ServerName = //newora/ORA5
UserID = asterisk
Password = asterisk
I have many works with pg, but no expirience with oracle.
Please, can you help me or give me a point of search?
hope very much for your help!
thanks in advance.