I am getting a strange error in my application. Its database error
-254 which is explained in informix manuals as :
The number of host variables that you named in the INTO clause of this
statement does not match the number of "?" place holders that you wrote
into the statement. Locate the text of the statement (in a PREPARE or
DECLARE statement), and verify the number of place holders. Then review
the list in the INTO clause to see which item is incorrect.
The application is running in produciton for almost 2 months and around
100 users are using it. But we got this error only a very few times.
When I try to simulate the problem I don't get it. When I asked the user
to come out of the application and run it again it worked fine. I know
this error comes if pass fewer or more host variables to a prepared
statement but I can't understand why it works sometimes and fails
This error started coming up once we changed the lock level of tables to
row from page. I don't know if that had affected this.
Any help will be greatly appreciated. If possible send a copy of your
We are using Informix version 7.3x on Hp-ux 10.20