Re: [ODBC] Stored Procedures

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Minal A(dot) Aryamane" <minalac(at)yes2etl(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Stored Procedures
Date: 2006-01-16 17:46:34
Message-ID: 9717.1137433594@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-odbc

"Minal A. Aryamane" <minalac(at)yes2etl(dot)com> writes:
> the function is as below:
> ...
> SET COURSEIDS1:=COURSEIDS;
> ...

This is completely off-topic for both the lists you have chosen, but
I'd say the problem is that you must not use the SET keyword when
assigning to a plpgsql local variable.

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Takeichi Kanzaki Cabrera 2006-01-16 18:06:09 Re: reading an oidvector field error
Previous Message Markus Schaber 2006-01-16 16:57:12 Re: [ODBC] Stored Procedures

Browse pgsql-odbc by date

  From Date Subject
Next Message Shachar Shemesh 2006-01-17 09:49:20 Updates on updates
Previous Message Markus Schaber 2006-01-16 16:57:12 Re: [ODBC] Stored Procedures