• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

Report based on Oracle stored procedure using Ref Cursor

Hi,

I am trying to base my report on oracle stored procedure. Procedure has 2 parameters like this

CREATE OR REPLACE procedure my_proc(
ioResults IN OUT my_pkg.rc,
cus_ref   IN varchar2
    )

my_pkg.rc IS refcursor in package my_pkg.

I am going by following steps to create report.

1. Create a blank report.
2. In dataexplorer going to desired database
3. selecting procedure my_proc.
4. Pressing Add button.
5. A 'Paramter window' is presented.
6. This window is only showing 'cus_ref' paramter only (omiting ioResults)
7. Pressing OK button.
8. An erroe message 'ODBC error : [MERANT][ODBR Oracle 8 Driver]Procedure contains a resultset, but Procedure Returns Results is not check'.

Question:
1. Why parameter ioResults is not displayed in parameter window.
2. Why am I presented with error message.

Your effor to answer this question will be very much appreciated.

Thanks
Rohit
0
rthanki
Asked:
rthanki
1 Solution
 
mjain109Commented:
Hi,

Try doing this. under the file menu, click on options. On the resulting window select the SQL tab. Under "Allow reporting on" check on Stored Procedures.

regards
mjain
0
 
kiransaluCommented:
You have check the "Procedure returns results" option in the Merant driver. Goto ODBC datasource and select the properties of your driver and do it.

I believe this should work fine.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now