Problem in calling prepare statement from STORED PROCEDURE

["Rajat Katyal" <rajatk@intelesoftech.com>]

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