Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to return cursor ?
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 ......................
END reports;
--
![]() |
![]() |