Re: Stored Proc w/Multiple Result Sets?

Gary Fidler wrote:

> I am trying to write a simple stored procedure which returns multiple
> result sets. I have done this on Sybase servers and wish to do the same on
> Oracle 7.*. The server whines about needing an INTO clause.
>
> What am I doing wrong?
>
> My example is:
>
> create or replace procedure username.sp_test
> (
> Arg1 varchar2,
> Arg2 varchar2
> )
> AS
>

variable1 number;
variable2 number;
....
variablen number;

> BEGIN
> select
> field1,
> field2,
> field3

INTO variable1, variable2, .... variablen !!!!!!!

> from
> username.table1
> where
> field1 = Arg1 and
> field2 = Arg2;
>
> select
> field1,
> field2,
> field3,
> field4
> from
> username.table2
> where
> field1 = Arg1 and
> field2 = Arg2;
> END;
>
> Thanks
> Gary

Regards

michael Received on Tue Sep 16 1997 - 00:00:00 CDT