Stored Proc w/Multiple Result Sets?

From: Gary Fidler <gfidler_at_aeq.com>
Date: 1997/09/15
Message-ID: <5vk51r$521$1@news-2.csn.net>#1/1

 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
BEGIN
select
  field1,
  field2,
  field3
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 Received on Mon Sep 15 1997 - 00:00:00 CDT