Data source error executing stored procedure

3 posts, 1 answers
  1. Stephen
    Stephen avatar
    3 posts
    Member since:
    Feb 2012

    Posted 27 Jan Link to this post

    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. Answer
    Nasko
    Admin
    Nasko avatar
    909 posts

    Posted 28 Jan Link to this post

    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
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  3. DevCraft banner
  4. Stephen
    Stephen avatar
    3 posts
    Member since:
    Feb 2012

    Posted 29 Jan in reply to Nasko Link to this post

    thank you that does work

Back to Top