Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do I do a simple select in a stored procedure
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