Re: 16 parameter limit - Mailing list pgsql-sql

From Barry Lind
Subject Re: 16 parameter limit
Date
Msg-id 3CAE8935.9020503@xythos.com
Whole thread Raw
In response to Re: 16 parameter limit  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql

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



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: 16 parameter limit
Next
From: d_nardini@btconnect.com
Date:
Subject: Re: intersect performance (PG 7.1.3 vs 7.2)