Re: Stored Proc w/Multiple Result Sets?

From: SKMGMT <skmgmt_at_aol.com>
Date: 1997/09/17
Message-ID: <19970917021801.WAA21237@ladder01.news.aol.com>#1/1

Hi:

In a PL/SQL block in oracle you have to select values into variables. In your case you should declare variables for the fields with datatypes matching with the datatypes of selected fields. Then with the help of an into clause select the valuse of the fields into the corresponding variables.
eg.
Create or replace procedure pro1 (Arg1, Arg2) as

       Var1    %type
       Var2    %type
        Var3   %type
        Var4   %type

Begin
Select field1, field2, field3, field4 into var1, var2, var3, var4 from table_name.

Rajesh Received on Wed Sep 17 1997 - 00:00:00 CDT