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 -> Oracle function returning set of rows

Oracle function returning set of rows

From: ind_123 <dhulapati_at_gmail.com>
Date: Thu, 16 Aug 2007 07:04:56 -0700
Message-ID: <1187273096.866683.35220@m37g2000prh.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:04:56 CDT

Original text of this message

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