Re: How to return cursor ?

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 Received on Wed Sep 22 1999 - 10:33:30 CDT