rthanki
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
I believe this should work fine.
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