IT41959: THE DATADIRECT ORACLE ODBC DRIVER INCORRECTLY DESCRIBES A PARAMETER THAT FOLLOWS A DATABASE FUNCTION CALL.

APAR status

• Closed as change to accomodate OEM Vendor's code.

Error description

• When inserting data into an Oracle database the parameter
  following a call to a database function
  
  is incorrectly described by the DataDirect Oracle ODBC driver.
  
  
  For example
  INSERT INTO MY_TABLE (MY_STATUS_ID, MY_DATE)
  VALUES(MY_DB_FUNCTION(?), ?);
  may result in this error
  [IBM][ODBC Oracle Wire Protocol driver]Unable to convert
  parameter 2. Cannot convert from C type 4 to SQL type 93
  if MY_DATE is a TIMESTAMP column.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of App Connect Enterprise Version 11 or Version 12 who
  use Oracle database function calls.
  
  
  Platforms affected:
  AIX, Linux on Power platform, Linux on x86-64 platform, Linux on
  zSeries platform, Windows on x86-64 platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  When inserting data into an Oracle database the parameter
  following a call to a database function is incorrectly described
  by the DataDirect Oracle ODBC driver.
  
  
  For example
  INSERT INTO MY_TABLE (MY_STATUS_ID, MY_DATE)
  VALUES(MY_DB_FUNCTION(?), ?);
  may result in this error
  [IBM][ODBC Oracle Wire Protocol driver]Unable to convert
  parameter 2. Cannot convert from C type 4 to SQL type 93
  if MY_DATE is a TIMESTAMP column.
  

Problem conclusion

• A new DataDirect Oracle ODBC driver that fixes the error is now
  supplied with App Connect Enterprise.
  

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

Applicable component levels