Calling Oracle Stored Procedure with Parameters that return a RefCursor

  • EdmandLooi 1 week, 2 days ago


    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)

  • 51p
    Deepak Sharma51p 1 week, 1 day ago


    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

    Deepak Sharma

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.