Returning a result set from a table using a stored procedure

From: Ajay Soni <ajay_at_thetunnel.demon.co.uk>
Date: Mon, 06 Jul 1998 16:01:04 GMT
Message-ID: <01bda8f6$921f7c00$9a6adec2@ajaytosh>

Hi,

We're trying to return a table by calling a stored procedure which has a select clause inside ( which looks like SELECT * FROM MYCUSTOMERS ).

Example:

>EXECUTE GET_CUSTOMERS
Returns:

Surname Firstname Address

---

Smith John 123 Broadway

We know it's possible to do it in MSQL Server, but how can it be done in Oracle 7.x

Cheers

Ajay Received on Mon Jul 06 1998 - 11:01:04 CDT