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

In article <600c339e.0204230523.7303050d_at_posting.google.com>, fatboyrider_at_hotmail.com says...
>
>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

read
http://osi.oracle.com/~tkyte/ResultSets/index.html

it is not significantly different.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp