| From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
|---|---|
| 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 08:54:45 |
| Message-ID: | 20060116085444.GA16920@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-odbc |
Mon, Jan 16, 2006 at 02:03:48PM +0530, Minal A. Aryamane napsal(a):
> I am trying to pass values through a jsp page wherein I am accessing
> this stored procedures by the following select ststemet
...
> when I run it I get the following error:
> ERROR: syntax error at or near "$1" at character 6
> CONTEXT: PL/pgSQL function "sp_build_course" line 45 at SQL statement.
>
> Can someone please look into the procedure and tell me where I have
> gone wrong.
Are you sure you choose the right pgsql lists?
Does it work from psql command line client? If not it isn't odbc or jdbc
related.
Regards,
Luf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Minal A. Aryamane | 2006-01-16 09:48:22 | Re: [ODBC] Stored Procedures |
| Previous Message | Minal A. Aryamane | 2006-01-16 08:33:48 | Stored Procedures |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Minal A. Aryamane | 2006-01-16 09:48:22 | Re: [ODBC] Stored Procedures |
| Previous Message | Minal A. Aryamane | 2006-01-16 08:33:48 | Stored Procedures |