Thread: function parameters

function parameters

From
Antonini Roberto
Date:

When I invoke DB-side function, I can’t pass more than 16 parameters to it.

Is it a limit imposed by JDBC driver?

If it’s so, how can I override it?

 

Thanks,

Roberto.

 

Gruppo Telecom Italia - Direzione e coordinamento di Telecom Italia S.p.A.

====================================================================
CONFIDENTIALITY NOTICE
This message and its attachments are addressed solely to the persons
above and may contain confidential information. If you have received
the message in error, be informed that any use of the content hereof
is prohibited. Please return it immediately to the sender and delete
the message. Should you have any questions, please send an e_mail to
MailAdmin@tilab.com. Thank you
====================================================================

Re: function parameters

From
Kris Jurka
Date:

On Mon, 13 Sep 2004, Antonini Roberto wrote:

> When I invoke DB-side function, I can't pass more than 16 parameters to
> it.
>
> Is it a limit imposed by JDBC driver?
>
> If it's so, how can I override it?
>

This is a backend limitation, although the default was increased to 32 in
the 7.3 release I believe.  To raise this requires some manual hacking on
config headers, try searching the archives for INDEX_MAX_KEYS.  Another
option is to use complex types or arrays to pass multiple inputs in the
same parameter.

Kris Jurka