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

Thread: Result Set

  1. 01-01-2001, 05:44 AM #1
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hi,
    Does anyone can tell me if Oracle can return a Result Set or Record Set from a PL/SQL block ?
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer
    Reply With Quote Reply With Quote
  2. 01-01-2001, 10:38 AM #2
    jmodic
    jmodic is offline Super Moderator
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, if you are using 7.2 or higher you can use "REF CURSOR", which enable you to return a result set.

    For detailed explanation and various examples see [url]http://osi.oracle.com/~tkyte/ResultSets/index.html[/url]

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?
    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