Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to return a result set from a stored proc?
try this (code has not been tested!! maybe syntax problems) :
create or replace package MYPACK as
type MYTYPE is ref cursor;
procedure MYPROC( result IN OUT MYTYPE, other parameters... );
end;
create or replace procedure MYPROC( result IN OUT MYTYPE, other
parameters... )
as
open result for select * from whatyouwant;
end
from ODBC, for example, call
--> SQLExecDirect -> "{call MYPACK.MYPROC( parameters but NOT THE
FIRST ) }"
if you do not use ODBC, you will certainly have to give the cursor as first
parameter
HTH
Christian
"Alexander Jerusalem" <ajeru_at_my-deja.com> a écrit dans le message news:
8fefdl$18t$1_at_nnrp1.deja.com...
> 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.
Received on Thu May 11 2000 - 00:00:00 CDT