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