Re: How to return a result set from a stored proc?

In article <8fega1$2i9$1_at_nnrp1.deja.com>,   Alexander Jerusalem <ajeru_at_my-deja.com> wrote:
> Hi,
>
> The subject basically says it all. I switched to Oracle from SQL-
> Server. In SQL-Server I could return a result set to the calling
> program from a stored procedure just by executing a sql statement. The
> same doesn't work in Oracle though. Following is my guess, which is
 not
> working:
>
> create or replace procedure (id in number) as
> begin
> select a, b, c from test where testId = id;
> end;
>
> Any hint would be very much appreciated.
>
> --
> Alexander Jerusalem
> VKN
> ajeru_at_gmx.net
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

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

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.