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

Thread: stored procedure can return recordset?

  1. #1
    Join Date
    Feb 2002
    Posts
    10
    Hi

    anyone have idea abt returing recordset from stored procedure as i use to do in sql server stored procedure.
    sql server has capacity to return result set which is use in crystal report for drawing reports. as thr any way i do same, returing recordset from oracle 8i stored procdure and then use it in oracle report builder.
    thanx in advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I havent used report builder.

    But oracle does have something to return reseult sets, it's called REF CURSOR. Look at docs to see how does it work

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    What you need is a collection either index-by table, nested table or a VARRAY depending on your record set. Create your collection using CREATE TYPE, define your record set variable, fetch it using BULK COLLECT and return it as that TYPE. Then you can pass that record set to another procedure, report etc.,
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

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