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  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Re: Problem in calling prepare statement from STORED PROCEDURE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Jeffrey R. Greco"
Дата:
Сообщение: namespace dilemma
Следующее
От: Mathias Picker
Дата:
Сообщение: postgres 7.4.2: float(20) results in error msg, but should not since 7.4)