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 по дате отправления