Re: How to return cursor ?

Thomas,

        Thanks for the URL. Your article just helped us solve our ODBC problem. We had an old driver. It now works like a charm.

Thanks again.
Rob Calfee

On Wed, 22 Sep 1999 11:33:30 -0400, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>A copy of this was sent to "Tolik K." <tol2000_at_geocities.com>
>(if that email address didn't require changing)
>On Wed, 22 Sep 1999 17:33:23 +0300, you wrote:
>
>>How can i return cursor from PL/SQL function in the package ?
>>PLEASE TELL ME HOW TO CORRECT THIS CODE TO RETURN CURSOR
>>
>>CREATE OR REPLACE PACKAGE BODY reports IS
>>
>> FUNCTION rep_book_sell_days(date_begin IN DATE, date_end IN DATE)
>> RETURN ????? IS
>> CURSOR rep_book_sell_days_cursor(date_beg DATE, date_e DATE) IS
>> SELECT ......................
>> BEGIN
>> RETURN rep_book_sell_days_cursor(date_begin, date_end); ??????
>> END rep_book_sell_days;
>>
>>END reports;
>
>see the url in my signature. I have a paper there 'returning result sets from
>stored procedures'.
>
>--
>See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
>Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
>Thomas Kyte tkyte_at_us.oracle.com
>Oracle Service Industries Reston, VA USA
>
>Opinions are mine and do not necessarily reflect those of Oracle Corporation

Rob Calfee
DBA
rcalfee_at_incsystem.com Received on Wed Sep 22 1999 - 11:02:23 CDT