Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-02!sn-xit-06!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: Oracle reports 10g and stored proc (ref cursor) Date: Thu, 03 Mar 2005 12:16:36 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1109880806.596666@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1109874259.541104.41890@o13g2000cwo.googlegroups.com> <1109876238.295350.76900@l41g2000cwc.googlegroups.com> In-Reply-To: <1109876238.295350.76900@l41g2000cwc.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 62 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:67679 joet11@comcast.net wrote: > 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 If you have any problems contact me off-line and I can put you in touch with the person that guest lectures for me at the University of Washington on Oracle Reports. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)