We are getting an error "[DataDirect][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 26".What could be possible reasons?

We are getting an error "[DataDirect][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 26".What could be possible reasons?

book

Article ID: KB0090550

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
"[DataDirect][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 26"-> indicates that it is unable to insert data into the parameter 26.

However, in practice there are several possible causes, including (but not limited to) :
   1. Data being inserted into a column is larger than the column definition.
   2. Data contains wide characters
   3. Oracle 8 Client connecting to an Oracle 9 Server

Issue/Introduction

We are getting an error "[DataDirect][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 26".What could be possible reasons?