IBM Support

Validation of store procedures that have complex types (STRUCT/ARRAY) as parameters

Troubleshooting


Problem

In the external service wizard, you can validate a stored procedure by providing sample input value. If all the input values are correct and the stored procedure is executed successfully, the validation is successful. However, WebSphere Adapter for JDBC does not validate the input values strictly in the external service wizard. If the format of an input value is incorrect, especially the input value for an attribute of a complex type parameter, the adapter ignores the input value and it sets the corresponding parameter to null. In some instances, it might validate the stored procedure as successful, instead of failing the validation.

Symptom

Though the input value is incorrect, the stored procedure validation is successful.

Resolving The Problem

Provide correct input value for all input parameters of the stored procedure before validation.

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter for JDBC","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.0;6.2","Edition":"WebSphere","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 June 2018

UID

swg21423002

Page Feedback