Problem in calling prepare statement from STORED PROCEDURE

From: "Rajat Katyal" <rajatk(at)intelesoftech(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Problem in calling prepare statement from STORED PROCEDURE
Date: 2004-04-03 08:38:44
Message-ID: 000901c41957$136a01a0$2105a8c0@bgdev001
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mathias Picker 2004-04-03 12:54:40 postgres 7.4.2: float(20) results in error msg, but should not since 7.4)
Previous Message Jeffrey R. Greco 2004-04-03 05:27:20 namespace dilemma