Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I do a simple select in a stored procedure

Re: How do I do a simple select in a stored procedure

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Tue, 23 Apr 2002 09:52:24 -0500
Message-ID: <s7tacu0tmtdgdel126fgp3draceq932hdj@4ax.com>

Check the Oracle docs for REF CURSOR

fatboyrider_at_hotmail.com (GB) wrote:

>I am a user of Visual Basic / SQL Server and have found myself
>responsible for doing a conversion to Oracle. In a stored procedure,
>it seems that a simple select of multiple rows (Select * from MyTable)
>from a table has to be done in a different way. Using in-line SQL from
>my VB program works fine of course. I have gathered that I need to use
>a cursor, my question is what syntax do I use to return the individual
>rows as if I just used in-line SQL from my VB program. Thanks for any
>help!
>
>G

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Apr 23 2002 - 09:52:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US