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:
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
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21596616