I am using Oracle 11g as an Oracle Database server and I am trying to connect to one of Oracle Database from Microsoft Report Builder through the Oracle Provider for OLE DB, everything was working as expected until I tried to use Stored Procedure as Query type in SSRS DataSet, and I got this error ORA-06550: line 1, column 7: PLS-00201: identifier must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored.
In the Datasource setting, I am using Oracle Provider for OLD BD that connects successfully!
Also, it's the DataSet settings where the Stored Procedure List is not listed in SSRS Microsoft Report Builder as displayed below
And when I typed the Stored procedure name manually, then click refresh fields, I got this error
ORA-06550: line 1, column 7: PLS-00201: identifier must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored.
Below is a copy from my Oracle stored procedure that I am trying to call in SSRS Report Builder?
create or replace NONEDITIONABLE PROCEDURE PROCEDURE2(cursorParam OUT SYS_REFCURSOR,icode in VARCHAR )
OPEN cursorParam FOR
SELECT * from SYSB.Table1 where IDCODE = icode;
The above Oracle Stored Stored run successfully in Oracle DB Server but I can't use it in SSRS report Builder, WHY?