PI61721: UNABLE TO INSERT DATA INTO AN ORACLE CLOB COLUMN USING A STORED PROCEDURE

APAR status

• Closed as program error.

Error description

• Using WTX it is not possible to use a stored procedure to insert
  data into an Oracle table that has a CLOB datatype definition
  for one of the columns.
  

Local fix

• WTXCQ - WTX00048485
  PB / PB
  Circumvention: None
  

Problem summary

• Users Affected:
  IBM Transformation Extender Oracle adapter users that require
  standalone CLOB support in stored procedure invocations
  
  Problem Description:
  Oracle stored procedure invocations do not support standalone
  CLOB types.
  
  Platforms Affected:
  All
  

Problem conclusion

• The Oracle CLOB type is supported in stored procedure
  invocations.
  
  Applies to:
  9.0.0.0
  
  
  Fixed in the next service packs and releases.
  
  To obtain the fix for this APAR:
  
  To see if the next service pack or product release is available,
  check the WebSphere Transformation Extender Downloads page:
  http://www.ibm.com/support/entry/portal/product/other_software/t
  ransformation_extender
  
  If the service pack or product release is available, download it
  from PassportAdvantage:
  http://www.ibm.com/software/howtobuy/passportadvantage/pao_custo
  mers.htm
  
  If the service pack or product release is not available and you
  require the APAR fix immediately, request a Limited Availability
  Interim Fix (LAIF) by opening a PMR:
  https://www.ibm.com/support/servicerequest/Home.action
  
  Prior to version 9.0.0, IBM Transformation Extender was called
  IBM WebSphere Transformation Extender.
  

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

• R900 PSY

     UP