Re: Oracle function returning rows

From: <fitzjarrell_at_cox.net>
Date: Thu, 16 Aug 2007 07:42:53 -0700
Message-ID: <1187275373.533027.16910@k79g2000hse.googlegroups.com>

On Aug 16, 9:05 am, ind_123 <dhulap..._at_gmail.com> wrote:
> 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;

Cross-posting doesn't help you.

A response needing your attention is already posted in comp.databases.oracle.server.

David Fitzjarrell Received on Thu Aug 16 2007 - 09:42:53 CDT