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!
![Oracle Provider for OLED to read stored procedure in SSRS Report Builder](https://debug.to/?qa=blob&qa_blobid=4751494811053430384)
Also, it's the DataSet settings where the Stored Procedure List is not listed in SSRS Microsoft Report Builder as displayed below
![Stored Procedure List is not listed in SSRS Microsoft Report Builder](https://debug.to/?qa=blob&qa_blobid=8456292184755166629)
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.
![ORA-06550: line 1, column 7: PLS-00201: identifier must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored.](https://debug.to/?qa=blob&qa_blobid=2738847810065408417)
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 )
IS
BEGIN
OPEN cursorParam FOR
SELECT * from SYSB.Table1 where IDCODE = icode;
END ;
The above Oracle Stored Stored run successfully in Oracle DB Server but I can't use it in SSRS report Builder, WHY?