IBM Support

Calling Oracle stored procedure with both parameter bindings and reference cursors fails

Troubleshooting


Problem

Executing an Oracle stored procedure that has both parameter bindings and Oracle reference cursors fails on the IBM WebSphere DataPower SOA Appliance. Sample snippet of such an sql-execute call: 02100002

Symptom

An error similar to the following will be logged:

sql-source (SQLDataSourceObj): Database reported query error: ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'STORED_PROC_NAME' ORA-06550: line 1, column 8: PL/SQL: Statement ignored

sql-source (SQLDataSourceObj): Database reported query error: ORA-06550: line 1, column 46: PLS-00302: component 'STORED_PROC_NAME' must be declared ORA-06550: line 1, column 8: PL/SQL: Statement ignored

Cause

Executing a stored procedure that has both parameter bindings and Oracle reference cursors is currently not supported.

Resolving The Problem

The current support for executing reference cursors is as documented in the following developerWorks article and technote:

Using Oracle cursors in WebSphere DataPower SOA Appliances

Invalid parameter binding(s) error when calling a stored procedure with a reference cursor output parameter

[{"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateway"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"General","Platform":[{"code":"PF009","label":"Firmware"}],"Version":"4.0.2;5.0.0;6.0.0;6.0.1","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21596616