IT46604: MAKING AN UPDATE OF MORE THAN 4044 CHARACTERS OF DATA TO A CLOB COLUMN IN AN ORACLE DATABASE CAUSES AN INVALID POSITION ERROR

APAR status

• Closed as program error.

Error description

• When attempting to UPDATE a CLOB column in an Oracle database
  with more than 4044 characters of data the ODBC driver reports
  the following error
  'HY000' SQL Native Error Code '-10' SQL Error Text '[IBM][ODBC
  Oracle Wire Protocol driver][Oracle]Invalid Position.'
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All Users of Ibm Integration Bus V10.1.0.4 and above, and App
  Connect Enterprise v12.0.12.0 and above using DataDirect Oracle
  ODBC driver.
  
  
  Platforms affected:
  AIX, Linux on Power platform, Linux on x86-64 platform, Windows
  on x86-64 platform, Linux on zSeries platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When attempting to UPDATE a CLOB column in an Oracle database
  with more than 4044 characters of data the ODBC driver reports
  the following error
  'HY000' SQL Native Error Code '-10' SQL Error Text '[IBM][ODBC
  Oracle Wire Protocol driver][Oracle]Invalid Position.'
  

Problem conclusion

• The product includes an updated level of ODBC drivers that
  resolves the problem.
  
  ---------------------------------------------------------------
  The fix is targeted for delivery in the following PTFs:
  
  Version    Maintenance Level
  v10.1      10.1.0.5
  v12.0      12.0.12.5
  
  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

  APP CONNECT ENT

• Fixed component ID

  5724J0560

Applicable component levels