Re: Return a dataset from a stored procedure?

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: 1997/07/02
Message-ID: <33BA3304.3911@bms.com>#1/1

Scott Dayton wrote:
>
> Does anyone know how or if a stored procedure or function can return a
> dataset similar to using select statement.
>
> ie.
> Instead of this
> SELECT * FROM EMP
> use this:
> SELECT * FROM <STORED PROCEDURE>
> --

Would something like this be what you're looking for?

    SELECT <STORED_FUNCTION>(EMPNO) FROM EMP;

---

Joe Kazimierczyk
kazimiej_at_bms.com Received on Wed Jul 02 1997 - 00:00:00 CDT