Postgres Pro
Downloads
Home   >   mailing lists

Problem in calling prepare statement from STORED PROCEDURE - Mailing list pgsql-general

From Rajat Katyal
Subject Problem in calling prepare statement from STORED PROCEDURE
Date
Msg-id 000901c41957$136a01a0$2105a8c0@bgdev001
Whole thread Raw
Responses Re: Problem in calling prepare statement from STORED PROCEDURE
Re: Problem in calling prepare statement from STORED PROCEDURE
List pgsql-general
Tree view
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 by date:

Previous
From: "Jeffrey R. Greco"
Date:
Subject: namespace dilemma
Next
From: Mathias Picker
Date:
Subject: postgres 7.4.2: float(20) results in error msg, but should not since 7.4)