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

From: julius <sdfdsf_at_swed.com>
Date: 2000/05/11
Message-ID: <jNBS4.77485$e61.2642618@zombie.newscene.com>#1/1

check thomas kyte web page, he provides the infor to do it

Thomas Kyte                              tkyte_at_us.oracle.com

Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html

In article <8fefdl$18t$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.
>
Received on Thu May 11 2000 - 00:00:00 CDT