Calling Oracle Stored Procedure with Parameters that return a RefCursor

  • EdmandLooi 1 week, 2 days ago

    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)

  • 51p
    Deepak Sharma51p 1 week, 1 day ago

    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

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

You must be logged in to reply to this topic.