HELP! A function which return a recordset

From: Dana Jian <dana_jian_at_hotmail.com>
Date: 2000/03/31
Message-ID: <38e52e68$0$29449@news.choice.net>#1/1

Hi,

I'm building a function in Oracle8i which need to return a recordset.

The recordset need to be created dynamically, which can be done by using DBMS_SQL, now my question is, how to return the result set??

Can I use Reference cursor? then How to save the value of DBMS_SQL.Column_Value variables into it? Or have to pass the result set in arrays??

Any help would be greatly appreciated!!
Dana
Dana_jian_at_hotmail.com Received on Fri Mar 31 2000 - 00:00:00 CST