Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

help

 
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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!