Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

SSRS and Stored Procedures

edited May 16, 2020 4:52AM in Database Install/Upgrade/Opatch (MOSC) 5 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center