Received: from barry.xythos.com (h-64-105-36-191.SNVACAID.covad.net
	[64.105.36.191])
	by postgresql.org (Postfix) with ESMTP id 2E63C475864
	for <pgsql-sql@postgresql.org>; Sat,  6 Apr 2002 00:36:03 -0500 (EST)
Received: from xythos.com (localhost.localdomain [127.0.0.1])
	by barry.xythos.com (8.11.6/8.11.6) with ESMTP id g365ZnP05182;
	Fri, 5 Apr 2002 21:35:54 -0800
Message-ID: <3CAE8935.9020503@xythos.com>
Date: Fri, 05 Apr 2002 21:35:49 -0800
From: Barry Lind <barry@xythos.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.9) Gecko/20020310
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Josh Berkus <josh@agliodbs.com>, Bruce Momjian <pgman@candle.pha.pa.us>,
	John Proctor <jproctor@prium.net>, pgsql-sql@postgresql.org
Subject: Re: 16 parameter limit
References: <web-1050933@davinci.ethosmedia.com>
	<10982.1018049639@sss.pgh.pa.us>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200204/78
X-Sequence-Number: 7343



Tom Lane wrote:
> "Josh Berkus" <josh@agliodbs.com> writes:
> 
>>However, we also want to support users who are porting their PL/SQL
>> applications, which may not be easily translated into %rowtype
>> paramters.
>
> Well, probably the $64 question there is: what is Oracle's limit on
> number of parameters?

According to the Oracle 9 documentation the limit for number of 
parameters to a function is 64K.

--Barry