MonitorWare Knowledge Base

How can I get the product to work with Oracle? I get the error:

SQLPrepare
SQLExecute FAILED
ODBC Error: SQLExecute failed
ODBC ERR MSG: 'ODBC Error Code: 'S1000'
ODBC Error Description: '[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column
'.'

Upon checking the ODBC log, I see two fields cast as LONG_VARCHAR (ODBC) types. If that has to be bound to an Oracle Long datatype, I have a problem because Oracle can only have one LONG field per table. Any idea? Can I configure the product to ignore some columns?

Dear Ken,

Oracle is unfortunaltey not on the list of officially supported platforms, but we know a lot of customers use it with success. In the Oracle schema you use, could you please check if the message filed is set to be a long value. It is in our default schemas for MS-SQL, MySQL and Jet. However, this is not absolutely necessary in most cases. If you define it to char(2048) or - something similar - that shold be fine. I guess (but do not know...) that this can solve your issue.

HTH
Rainer Gerhards
Adiscon