SSRS 2008 Using Stored Procedure with SysRef Cursor Oracle


  • Hi,

    I am new to SSRS.

    I have a ssrs procedure which runs to Return Result of Select Query. ( In form of SYS REF Cursor in Oracle ).

    When I am trying to see the Value in Test Window. It is showing Output. But when I m Running the Report in the environment it is giving me error.

    Please help me if there is a better way of handling it.

    As I read in some forum as SSRS has issue handling SYS Ref Cursor...


    Thanks Priyank Piyush

    Monday, August 25, 2014 11:13 PM


  • Hi Priyank,

    According to your description, you are use a Stored Procedure from SysRef Cursor Oracle as the report dataset. The query works well in Dataset Query Designer, while an error occurs when you render the report.

    As per my understanding, the problem is that there are something wrong with the report design. Please double-check the design of the report. In order to trouble shoot the problem more efficiently, could you please post the detail error message? Then we can make further analysis.

    Katherine Xiong

    Katherine Xiong
    TechNet Community Support

    Tuesday, August 26, 2014 10:53 AM