Re: Stored Procedures

Поиск
Список
Период
Сортировка
Искать
От
Ludek Finstrle
Тема
Re: Stored Procedures
Дата
Msg-id
20060116085444.GA16920@soptik.pzkagis.cz
Ответ на
Stored Procedures (Minal A. Aryamane)
Список
Дерево обсуждения
Stored Procedures "Minal A. Aryamane" <minalac@yes2etl.com>
Re: Stored Procedures Ludek Finstrle <luf@pzkagis.cz>
Re: Stored Procedures Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-odbc по дате отправления
От: Minal A. Aryamane
Дата:
Сообщение: Stored Procedures
От: Minal A. Aryamane
Дата:
Сообщение: Re: Stored Procedures
FAQ