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

[{"Product":{"code":"SS9H2Y","label":"IBM DataPower Gateway"},"Business Unit":{"code":"BU048","label":"IBM Software"},"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":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
15 June 2018

UID

swg21596616

Page Feedback