Report based on Oracle stored procedure using Ref Cursor

Posted on 2003-03-31
Medium Priority
Last Modified: 2008-02-01

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'.

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.

Question by:rthanki
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 101

Accepted Solution

mlmcc earned 200 total points
ID: 8238061

Expert Comment

ID: 8239845

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.


Expert Comment

ID: 8240832
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.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question