Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
arulraj michealraj
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Assume that you have the following query.


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
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 5093
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
more at home in the JDBC forum of course as it's a database specific problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic