PH62057: EXCEPTION USING THE ITX JDBC ADAPTER TO CALL AN ORACLE STORED PROCEDURE WITH BOTH INPUT AND OUTPUT PARAMETERS

APAR status

• Closed as program error.

Error description

• IBM Sterling Transformation Extender (ITX) maps that use the
  JDBC adapter to call an Oracle Stored Procedure that has both
  input and output parameters or arguments may result in an
  exception.
  
  Example correct syntax:
  
  =GET("JDBC","-URL jdbc:oracle:thin:@//VM16xORA2:1521/orac -USER
  user -PASSWORD password -LSN 0 -QTY 1 -TV -PROCEDURE
  P_FINDEMPNAME34 ","1")
  
  Example exception result:
  
  
  'Exception occurred - Infinite or NaN'
  

Local fix

• ITXCQ - ITX00062541
  PB / PB
  Circumvention: The syntax can be called with a final '|'
  character in place, but additional issues can arise due to
  memory corruption:
  
  =GET("JDBC","-URL jdbc:oracle:thin:@//VM16xORA2:1521/orac -USER
  user -PASSWORD password -LSN 0 -QTY 1 -TV -PROCEDURE
  P_FINDEMPNAME34 ","1|")
  

Problem summary

• Users Affected:
  IBM Transformation Extender users using JDBC adapter users who
  invoke stored procedures with input parameters that are passed
  to a GET/PUT or output card.
  
  Problem Description:
  Stored procedure input parameters were not getting properly
  parsed.
  
  Platforms Affected:
  All
  

Problem conclusion

• Stored procedures parameters are parsed without exceptions when
  called from a GET rule.  Before this fix, the input stream was
  getting corrupted with other heap-related data, which prevented
  proper parsing of the input parameters.
  
  Applies to:
  10.1.1.1, 10.1.2.1, 11.0.0.0, 11.0.1.0
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next fix pack or product release is available,
  check the IBM Transformation Extender product Release Notes
  page:
  https://www.ibm.com/support/pages/node/318755
  
  If a fix pack release is available, download it from Fix
  Central:
  http://www.ibm.com/support/fixcentral/
  
  If a new product release is available, download it from Passport
  Advantage:
  https://www.ibm.com/software/passportadvantage/pao_customer.html
  
  
  If the fix pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a support Case:
  https://www.ibm.com/mysupport
  

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

  ITX

• Fixed component ID

  5724Q2300

Applicable component levels