Re: Return a recordset from Oracle function/sp???

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 3 Dec 1999 23:41:58 +0100
Message-ID: <944261006.13104.0.pluto.d4ee154e@news.demon.nl>

Yes, you need to use a ref cursor.
There are examples on Thomas Kyte website, http://osi.oracle.com/~tkyte/

Hth,

--
Sybrand Bakker, Oracle DBA
Dana Jian <djian_at_trasa.com> wrote in message news:384836df$0$48657_at_news.choice.net...
> Hi everybody,
>
> I'm a new user of Oracle.
> My question is, is it possible to return a recordset (multiple rows with
> multiple columns) from Oracle function/stored procedure?? How?
>
> Thanks a lot for any help!
>
> Dana Jian
> dan_jian_at_hotmail.com
>
>
Received on Fri Dec 03 1999 - 16:41:58 CST