Re: Discussion on REF CURSOR

"M" <someone_at_microsoft.com> wrote:

>Hi all,
>
>I noticed that there's something called REF CURSOR in Oracle but I'm not
>familiar with this. Would someone just give me some brief intro and I'd
>investigate further?
>
>In particular,
>(1) is REF CURSOR is pure a oracle database construct?
>(2) is it used particularly in oracle tools like forms, reports, etc.?
>(3) could you quote some examples?
>
>TIA. M.
>
Go to
http://tahiti.oracle.com and search for REF CURSOR ( Or REFCURSOR )..

( or read your PlSql docs)
In brief( very brief):
A REF CURSOR ( REFCURSOR in actual usage syntax) is a data structure that can be returned by a Pl/Sql procedure and is somewhat analogous to a recordset ....

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu May 15 2003 - 16:07:27 CEST