Prepare / Execute Method Error

[Brad Budge <flexpadawan@xxxxxxxxx>]

I'm having problems passing in variables into my execute statement.� Any ideas?

Table:
CREATE TABLE cat.case
(
vari ������� character varying(50), ������������������ --Contains Value �BDD1�
ht ���������� numeric(4,1)������������������������������������� --Contains Value 30.0
)

Statements:
PREPARE insert_plan (character varying, numeric) AS
SELECT vari FROM cat.case WHERE vari = $1 AND ht = $2;

EXECUTE insert_plan(vari_string, case[1]);� --Fails with Errors
vari_string �������� = 'BDD1' ������������� --character varying
case[1] ��������������� = 30.0 ������������������ --numeric(4,1)[]

Errors:
NOTICE: vari_string: BDD1 NOTICE: ht: 30.0
ERROR: function insert_plan(character varying, numeric) does not exist
LINE 1: SELECT insert_plan( $1 , $2 [ $3 ])
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT insert_plan( $1 , $2 [ $3 ])

Hard Coded � It will work! It just doesn�t like using variables inside???
EXECUTE insert_plan('BDD1', 30.0);

�

Another Variation of the Execution Statement and still failed.
EXECUTE insert_plan(vari_string:: character varying(50), case[1]:: numeric(4,1));