• Post Reply Bookmark Topic Watch Topic
  • New Topic

help  RSS feed

 
Ashish Satsangi
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi all
i m facing a strange problem , when i am caling a oracle procedure from my java bean i am getting this java.sql.SQLException RA-01008 not all varaible bound error , plz help me to overcome this problem , this is very urgent for me.
thanks
Ashish
 
L Naik
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ORA-01008: not all variables bound
Cause: A SQL statement containing substitution variables was executed without all variables bound. All substitution variables must have a substituted value before the SQL statement is executed.
Check all that you have as many substitution variables (with a ?) when calling the stored procedures as many it is expecting.
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Um, first this is the Servlet forum, is your question about Servlets, or is it a JDBC question, or maybe an Oracle question. I think your issue resides with JDBC and how you bind variables to queries. So I am going to move this thread to the JDBC forum.
It could also be further within your Oracle stored procedure, if the code in there is calling other stored procedures.
Mark
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!