Re: Reports 6i - REF CURSOR
Date: Fri, 26 Jan 2001 01:22:55 GMT
Message-ID: <Pj4c6.19552$J%.1486443_at_news.flash.net>
[Quoted] I tried to use a ref cursor in reports 6i (with patch1) and it bombed with [Quoted] an error. Shortly afterwords, I couldn't open the report (.rdf file) again. [Quoted] I'm hoping this is fixed in a later release. I assume you mean basing [Quoted] your SQL query object on a refcursor, correct?
You could always base the report query on a file too, or populate the data outside the report and pass it in.
> Can you give me some detail on accessing an
> Oracle ref cursor from Reports 2.5 to create the
> report(instead of inline sql)? I can't find any
> documentation on using ref cursors. We will be
> upgrading to 6 soon, so any info. you have on 2.5
> or 6 will be greatly appreciated.
Received on Fri Jan 26 2001 - 02:22:55 CET