Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!l41g2000cwc.googlegroups.com!not-for-mail
From: joet11@comcast.net
Newsgroups: comp.databases.oracle.tools
Subject: Re: Oracle reports 10g and stored proc (ref cursor)
Date: 3 Mar 2005 10:57:18 -0800
Organization: http://groups.google.com
Lines: 43
Message-ID: <1109876238.295350.76900@l41g2000cwc.googlegroups.com>
References: <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 1109876242 22880 127.0.0.1 (3 Mar 2005 18:57:22 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 3 Mar 2005 18:57:22 +0000 (UTC)
In-Reply-To: <1109874259.541104.41890@o13g2000cwo.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: l41g2000cwc.googlegroups.com; posting-host=204.154.49.198;
   posting-account=Pytm8w0AAAAHxp3KiecGq52q3m7Ug0s4
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:67678

I did find the following approach which appears to work.  Any comments
as to whether this is the correct approach would be appreciated:
I created a query in the data model as follows: (it calls the procedure
P_TEST which exists in the db and the ref cursor is defined in the
package PKG_TEST)

function QR_1RefCurDS return PKG_TEST.CursorTEST is
  out_cursor PKG_TEST.CursorTEST;
begin
  P_TEST(42020,OUT_CURSOR);
  return OUT_CURSOR;
end;



Thanks - Joe


joet11@comcast.net wrote:
> 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