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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 04 Dec 1999 08:49:28 -0500
Message-ID: <hu6i4sc4schu0hdqtpt40rmt2taomb3lep@4ax.com>

A copy of this was sent to "Dana Jian" <djian_at_trasa.com> (if that email address didn't require changing) On Fri, 3 Dec 1999 16:32:15 -0500, you wrote:

>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
>

see http://osi.oracle.com/~tkyte/ResultSets/index.html

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Dec 04 1999 - 07:49:28 CST