IC82429: USER DEFINED TYPE NOT FOUND ERROR WHEN USING COMPLEX ORACLE DATA TYPES

APAR status

• Closed as program error.

Error description

• In Oracle when there is a complex structure or program package
  defined within a schema, and there is a public synonym defined
  to all allow global access to the structure and program package,
  DataPower will return the following error if the SQL
  Data Source object has a schema/user name that is not the owning
  schema of the artifacts.
  [sql][error] sql-source(sqlMyTest): tid(55480): Database
  reported query
  error: User defined type not found: DP.MYLIST
  
  Here user "Bob" owned the artifacts while schema/user of ?DP? on
  the DataPower SQL Data Source object resulted in this error.
  

Local fix

• Utilize the userid/schema name in the SQL Data Source Object
  that owns the complex structure.
  

Problem summary

• Affected is the use of DataPower with an Oracle database.
  
  Under certain circumstances, stored procedures invoked using
  public synonyms would fail to run properly.
  

Problem conclusion

• Stored procedures can be run using public synonyms to refer to a
  schema, package, or stored procedure itself in DataPower
  fixpacks 4.0.2.8, 5.0.0.1, and follow on fixpacks. This fix only
  applies to invoking the stored procedure itself; synonyms are
  not supported for procedure parameter types.
  
  Fix is available in 4.0.2.8 and 5.0.0.1
  

Temporary fix

• Invoke the stored procedure directly using its fully qualified
  name.
  

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

  DATAPOWER BLAD

• Fixed component ID

  DPBLADE01

Applicable component levels

• R402 PSY

     UP

• R500 PSY

     UP