Re: variable list of arguments to a pl/sql procedure

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 11 Jun 2005 09:06:41 -0700
Message-ID: <1118506013.647353@yasure>

HansF wrote:
> On Fri, 10 Jun 2005 09:02:38 -0500, Oxnard interested us by writing:
>
>
>

>>I would like some comments from others who have had to deal with simular 
>>issues.

>
>
> Create a table.
> Populate the table with the 'arguments'. (Use a unique key)
> Pass the key to the procedure instead.

Same solution with a global temporary table ... and no need to pass the unique key ... and in addition no logging overhead.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Sat Jun 11 2005 - 11:06:41 CDT