Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail
From: joet11@comcast.net
Newsgroups: comp.databases.oracle.tools
Subject: Oracle reports 10g and stored proc (ref cursor)
Date: 3 Mar 2005 10:24:19 -0800
Organization: http://groups.google.com
Lines: 20
Message-ID: <1109874259.541104.41890@o13g2000cwo.googlegroups.com>
NNTP-Posting-Host: 204.154.49.198
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1109874263 29583 127.0.0.1 (3 Mar 2005 18:24:23 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 18:24:23 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: o13g2000cwo.googlegroups.com; posting-host=204.154.49.198;
   posting-account=Pytm8w0AAAAHxp3KiecGq52q3m7Ug0s4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:67677

Hi;

We are looking at switching to Oracle Reports 10g from Crystal reports.
 I am trying to migrate one of the Crystal reports.  The Crystal report
gets its data input by calling an Oracle stored procedure (existing in
the DB) which returns a ref cursor.

I'd like to use that same stored procedure to feed the Oracle report.
However, I can only find documentation which describes how to save a
procedure into an external library via the Oracle reports
functionality.  Then attach that external libray to other reports.

I don't want to do that as there is no need to create it again.  I
simply want to call the existing stored procedure which already exists
in the DB and returns a ref cursor.

Any help on how this can be done will be greatly appreciated.

Thanks - Joe