ECPG and SQL function

Поиск

Список

Период

Сортировка

От	Michaël Fiey
Тема	ECPG and SQL function
Дата	24 августа 2000 г. 14:58:31
Msg-id	002701c00dfd$160e5960$6400a8c0@pc03 обсуждение исходный текст
Ответы	Re: ECPG and SQL function
Список	pgsql-general

Hi,

I wrote a sql funtion which accept 1 varchar in and return an int4.

I try to use this function in a C program with ECPG.

The command : "exec sql select myfunction('myargument') into :res" works fine

but :

"mycommand=select myfonction('mychangingargument')

sql prepare myprep from mycommand

and sql exec execute myprep" does not

and

"mycommand=select myfonction('mychangingargument') into :res

sql prepare myprep from mycommand

and sql exec execute myprep using :res" does not any more.

I got the error "Too few argument" or "Too many argument".

thanks for any kind of help.

В списке pgsql-general по дате отправления: