SSRS and Stored Procedures
Hi,
When I install 12c Client with Microsoft SSRS 2014 I receive an error when executing a Stored Procedure. System.Data.OracleClient.OracleException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'Q_PROC1'.
There are no issues with using 11g Client with the exact same code.
For example I have a package call to R_PACK1.Q_PROC1. This is defined on the database as CREATE OR REPLACE PACKAGE r_pack1 AS ... PROCEDURE q_proc1 (n_session NUMBER, c_out_cursor OUT SYS_REFCURSOR);
The reports use a Stored Procedure as their Query Type e.g.