I have a report that I'm trying to execute an Oracle stored procedure that has a NVARCHAR2 and NUMBER "in" parameters and a SYS_REFCURSOR "out" parameter. No matter which data source I use for Oracle I always get an error PLS 00306 wrong number or types of arguments in call to 'ProcedureName'.
I'm using the Telerik Report Designer Q3 2015 software to create the report. If I remove the sys_refcursor I can run the procedure just fine and it works; proven by quering the staging table after I execute from the report. From the report I send 2 parameters: 1 string and 1 int64. What do I need to add to get the results back from the sys_refcursor?