Re: Returning a record set with a stored procedure

In article <5a6ed0d7.0111210517.666e056f_at_posting.google.com>, rmctyre_at_hotmail.com says...
>
>I would like to create a simple stored procedure that consists of a
>single SELECT statement. Can you do this with Oracle? If so, can
>someone give me a hint on the syntax?
>
>Example:
>
>Table_A
>-------
>ProductId
>ProductDescription
>
>SELECT ProductId, ProductDescription
>FROM Table_A

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

...

--
Thomas Kyte (tkyte@us.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