Procedure to return a result set

From: Bob Weber <bweber_at_onramp.net>
Date: 1997/05/08
Message-ID: <01bc5bf1$a54e4f70$f964020a@baweber>#1/1

Ok! I give up!!
It's very simple under MS SQL to write a stored procedure which returns a result set. Unfortunately I can't seem to figure out how to do the same thing under ORACLE!!!

Could anyone help? let's say I want a procedure to SELECT PRICE FROM PRICE_TABLE WHERE VENDOR = :VEND how can i create a procedure to do this and how can i successfully execute ie. EXECUTE SP_PRICE( "ORACLE");
and then get back
PRICE

---

1.00
2.00
3.45

etc...

Sorry to seem so dense, but I seem to be missing something very basic! Thanks,
Bob Weber
bweber_at_onramp.net Received on Thu May 08 1997 - 00:00:00 CDT