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
posted 13 years ago
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.
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