Re: Returning multiple params from function

From: MStout2468 <mstout2468_at_aol.com>
Date: 20 Feb 1999 22:14:33 GMT
Message-ID: <19990220171433.22598.00000311@ngol02.aol.com>

Hi,

   Functions return one value.

   Procedures can use the OUT spec in the param list.

   This is off the top of my head, so check the manual for proper examples.

   create or replace procedure test (p1 in number, p2 in out number, p3 out number)

   is
   begin

     p2 := p1 + p2;
     p3 := p1 * p2;

   end test;

Mike Stout Received on Sat Feb 20 1999 - 16:14:33 CST