Calling Oracle Stored Procedure with Parameters that return a RefCursor

Originally Posted 10 August 2017, 1:12 am EST

  • Originally Posted 10 August 2017, 1:12 am EST

    Hi,

    I am using ActiveReports 11 and need to call an Oracle stored procedure with parameters and return result in a RefCursor. I have search the forum and did not find any clear instruction on what is needed to call an Oracle stored procedure. I have create a simple stored procedure and tested it with Oracle SQL developer tool. Could someone give me instruction on how to setup ActiveReport under the DataSource and DataSet section that is equivalent to the call below that I have test that works in Oracle SQL Developer?

    Thanks for any help you may provide.


    var c refcursor;
    execute MyStoredProc( sysdate()-1,sysdate(), :c)
  • Reply

    Hello,

    I have reported this issue to the concerned team. I will let you know as soon as I hear anything on this.
    Tracking id for this issue is:242351

    Regards,
    Deepak Sharma
  • Reply

    I'm having the same issue in ActiveReports v14. Has there been any progress on this issue?
  • Reply

    Hello,

    Currently we do not have a working sample application to demonstrate this. I would like to inform you that Oracle Client Provider in RDL and PageReports has a limitation, it does not support the stored procedures with 'SYS_REFCURSOR' but you can try to use OleDB client(MSDAORA) for Oracle, so if stored procedure has one input parameter and refcursor as output, e.g.:

    PROCEDURE PROC2
    (
    PARAM1 IN VARCHAR2
    , T2 OUT SYS_REFCURSOR
    )...

    then it can be called in the page report like PROC2(?,)

    Thanks,
    Mohit
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels