Re: Oracle function returning set of rows

"ind_123" <dhulapati_at_gmail.com> a écrit dans le message de news: 1187273096.866683.35220_at_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;
|

1/ "It doesnt work." is not an Oracle error message.
2/ function keyword is missing in your script
3/ copy and paste what you executed
4/ post your Oracle version

Regards
Michel Cadot Received on Thu Aug 16 2007 - 09:24:10 CDT