DBMS_SQL -> Ref Cursor

[chrisrlong]

I want to be able to use NDS or DBMS_SQL interchangeably in procedures that return result sets. For NDS, I do a simple OPEN p_RefCursor FOR l_SQL; In DBMS_SQL, I get cursor that I can fetch through and use to fill a BInary Index Table, but how can I convert the resultset returned from DBMS_SQL into a Ref Cursor?

Thanks,

- Chris

[chrisrlong]

Any thoughts out there?

- Chris