DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DBMS_SQL -> Ref Cursor

  1. 06-27-2001, 04:10 PM #1
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    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
    Reply With Quote Reply With Quote
  2. 06-28-2001, 01:18 PM #2
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Any thoughts out there?

    - Chris
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width