IT12570: BLOB PARAMETERS INCORRECTLY DESCRIBED AS VARCHAR WHEN USING PASSTHRU TO AN ORACLE DATABASE

APAR status

• Closed as program error.

Error description

• The Oracle ODBC driver can incorrectly describe BLOB columns.
  
  If you are using an ESQL PASSTHRU command to either UPDATE or
  INSERT to a column of type BLOB in an Oracle database it can be
  incorrectly described as being of type VARCHAR with a size of
  999 characters. If the data you are trying to INSERT or UPDATE
  is more than 999 characters then an error occurs.
  
  The error reported is "[IBM][ODBC Oracle Wire Protocol
  driver]Invalid precision value. Error in parameter n".
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus inserting or updating data in
  an oracle database using the ESQL PASSTHRU function.
  
  
  Platforms affected:
  MultiPlatform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When using the ESQL PASSTHRU function to INSERT or UPDATE a BLOB
  column in an Oracle database an ODBC error is reported. The
  error is reported when the data being inserted or updated is
  more that 999 characters in length.
  
  An example of the type of error message received is
  [IBM][ODBC Oracle Wire Protocol driver] Invalid precision value.
  Error in parameter 1.
  
  The error is caused by the DataDirect Oracle Wire Protocol ODBC
  driver incorrectly describing the BLOB column as being a VARCHAR
  column with a length of 999 characters.
  

Problem conclusion

• The product includes an updated level of the DataDirect Oracle
  Wire Protocol ODBC driver that resolves the problem.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.0      10.0.0.4
  
  The latest available maintenance can be obtained from:
  http://www-01.ibm.com/support/docview.wss?rs=849&uid=swg27006041
  
  If the maintenance level is not yet available,information on
  its planned availability can be found on:
  http://www-1.ibm.com/support/docview.wss?rs=849&uid=swg27006308
  ---------------------------------------------------------------
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INTEGRATION BUS

• Fixed component ID

  5724J0540

Applicable component levels

• RA00 PSY

     UP