Hi All ,
I am trying to generate a report using SSRS( SQL server reporting services ). when I try to execute stored procedures I am getting below error. any help on this would be appreciated.
Below are the details of enviroment.
1. SQl serverr 2012
2.Oracle 12c client
3.Oracle Server 12c
4.Visual studio 2013
Query without input parameters
///////////////////////////////////////////////////////////////////
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'STOREDPROCEDURE_CODE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
///////////////////////////////////////////////////////////////////
procedure returning data from SQL developer
Query with input parameters
//////////////////////////////////////////////////////////////////
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'XXXXXXXXXXXXXXXXXXXX'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
/////////////////////////////////////////////////////////////////////