DBMS_SQL -> Ref Cursor
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_SQL -> Ref Cursor

  1. #1
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Any thoughts out there?

    - Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width