Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] Stored Procedures

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 (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-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

In response to

Responses

pgsql-odbc by date

Next:From: Minal A. AryamaneDate: 2006-01-16 09:48:22
Subject: Re: [ODBC] Stored Procedures
Previous:From: Minal A. AryamaneDate: 2006-01-16 08:33:48
Subject: Stored Procedures

pgsql-jdbc by date

Next:From: Minal A. AryamaneDate: 2006-01-16 09:48:22
Subject: Re: [ODBC] Stored Procedures
Previous:From: Minal A. AryamaneDate: 2006-01-16 08:33:48
Subject: Stored Procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group