HELP! Dynamic SQL

From: Dana Jian <dana_jian_at_hotmail.com>
Date: Fri, 31 Mar 2000 18:03:11 -0500
Message-ID: <38e52eb0$0$29454@news.choice.net>

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 - 17:03:11 CST