This question is locked. New answers and comments are not allowed.
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?
2 Answers, 1 is accepted
0
Accepted
Hello Stephen,
The issue has been fixed in the latest official release of Telerik Reporting:
"Fixed: Report parameter's values are not sent correctly to an Oracle stored procedure with sys_refcursor out parameter"
You can check the release notes here.
Regards,
Nasko
Telerik
The issue has been fixed in the latest official release of Telerik Reporting:
"Fixed: Report parameter's values are not sent correctly to an Oracle stored procedure with sys_refcursor out parameter"
You can check the release notes here.
Regards,
Nasko
Telerik
Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
0
Stephen
Top achievements
Rank 1
Iron
Iron
Rank 1
Iron
Iron
answered on 29 Jan 2016, 08:37 PM
thank you that does work