Error running OE Prepared Statement

Hi all,

I have been trying to run OpenEdge Prepared Statements in Sonic, but having some weird problems.

My query is as under:

insert into pub.transactions(tranamt,trantype,traaccid,tradate) values(@amount,'CREDIT',@transferer,'2008-12-21');

Here the parameters preceded by '@' are to be supplied at runtime by Sonic.

However at runtime due to some reasons the parameters are not replaced by actual values.

Interesting fact is that if I used a single input parameter in place of two, the query would run successfully.

I guess there is some configuration needed to be set for OpenEdge Driver to work for more than 1 input parameter.

Also, I have tried the same with other databases. There is no such issue.

Any help would be appreciated,

Thank you