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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle function returning rows

Oracle function returning rows

From: ind_123 <dhulapati_at_gmail.com>
Date: Thu, 16 Aug 2007 07:05:46 -0700
Message-ID: <1187273146.412686.155430@q4g2000prc.googlegroups.com>


How can I write an oracle function that can return a set of rows? this is what I am doing now. It doesnt work.
create or replace FN_ABCD
(
reportdate in DATE
)
RETURN types.ref_cursor
as
l_cursor types.ref_cursor;

begin
open l_cursor for
 SELECT.....   return l_cursor;
end FN_ABCD; Received on Thu Aug 16 2007 - 09:05:46 CDT

Original text of this message

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