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

i just had a look to this web site, but i think the Stored Proc (in the example) must be defined in a package to be visible from ODBC.

HTH
Christian

"julius" <sdfdsf_at_swed.com> a écrit dans le message news: jNBS4.77485$e61.2642618_at_zombie.newscene.com...
>
> 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 Fri May 12 2000 - 00:00:00 CDT