Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle function returning rows
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
![]() |
![]() |