Problem in calling prepare statement from STORED PROCEDURE

Поиск
Список
Период
Сортировка
От Rajat Katyal
Тема Problem in calling prepare statement from STORED PROCEDURE
Дата
Msg-id 000901c41957$136a01a0$2105a8c0@bgdev001
обсуждение исходный текст
Ответы Re: Problem in calling prepare statement from STORED PROCEDURE
Re: Problem in calling prepare statement from STORED PROCEDURE
Список pgsql-general
Hi:
 
I prepare the statement for execution as follows:
 
PREPARE query(text) as SELECT count(*) FROM transform_customer_billing where inv_no = $1;
 
The problem is Iam not able to execute this prepare statement from the stored procedure defined. I added the statement to call the prepare statement is: EXECUTE query('100023'). The ERROR it prints : Function query(text) does not exist.
 
Please suggest the solution for this problem.
 
Thanks in advance.
 
Rajat

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