Returning a record set with a stored procedure

From: Russ McTyre <rmctyre_at_hotmail.com>
Date: 21 Nov 2001 05:17:35 -0800
Message-ID: <5a6ed0d7.0111210517.666e056f@posting.google.com>

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 Received on Wed Nov 21 2001 - 07:17:35 CST