what is "ora-01008:not all variables bound"

[arulraj michealraj]

An unexpected exception was thrown:

javax.servlet.ServletException: ORA-01008: not all variables bound

With the following stack trace:

javax.servlet.ServletException: ORA-01008: not all variables bound


What is the meaning of this problem?

please help me immediately.

thanks
Arulraj

[Mani Ram]

Assume that you have the following query.

SELECT * FROM EMP WHERE NAME = ? AND AGE = ?

Now, there are two replacement parameters in the query, denoted by 2 question marks. You need to set values for both of the replacement parameters

For example
ps.setString(1, "John");
ps.setInt(2, 30);

If you miss to set the value for any of the replacement parameters, you get this exception. Check whether you have enough setXXX methods for the number of ? you have in the query.

[Jack Wiesenthaler]

It means you have a PreparedStatement or CallableStatement in which you've not set all the parameters. Recheck to see that all parameters have been set and if your calling a stored procedure check to see that the number of parameters in your call matches the procedure in the database.

[Jeroen Wenting]

more at home in the JDBC forum of course as it's a database specific problem.