Stored procedures

From: "Yolanda Phillips" <yphillips(at)dlkconsulting(dot)co(dot)za>
To: "'Pgsql-Jdbc(at)Postgresql(dot) Org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Stored procedures
Date: 2003-10-03 05:47:04
Message-ID: BDEGIDIMOFKAPOPFANEFKEBOEJAA.yphillips@dlkconsulting.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Good day,

I need help URGENTLY!!

I'm trying to compile a Stored Function that performs either an insert or an
update on a table. The function has 44 input parameters and returns an
integer. When compiling the function a get an error:

ERROR: functions cannot have more than 32 arguments

I would just like someone to confirm this. Can a function only have 32 input
parameters? If so, I'd have to use Prepared Statements then.

Thank you in advance.

Sincerely,

Yolanda Phillips
Web Applications Developer

Attachment Content-Type Size
winmail.dat application/ms-tnef 1.8 KB

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Gordon Ross 2003-10-03 07:43:56 Concurrent Connections - User only allowed one connection
Previous Message balaji 2003-10-03 02:37:38 Postgresql 7.3.4 download problem