Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to return cursor ?

How to return cursor ?

From: Tolik K. <tol2000_at_geocities.com>
Date: Wed, 22 Sep 1999 17:33:23 +0300
Message-ID: <7sap5c$9ta$1@toster.Te.NeT.UA>


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;

--



Tolik.
e-mail: tol2000_at_geocities.com Received on Wed Sep 22 1999 - 09:33:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US