• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

ORA-01008: not all variables bound

 
Rr Kumaran
Ranch Hand
Posts: 548
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am getting sql exception saying "ORA-01008: not all variables bound" when I was trying to execute a sql on oracle database. How do I actual print the table column name that is giving such error. Does the JDBC api provide easy methods to trace without putting check/debug points to trace the problem ?


Thanks & Regards,
Gurudatta.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No. That's an Oracle exception, so all JDBC is doing is repeating what Oracle is telling it. A "not all variables bound" error should easy enough to spot though - you should be a ble to see that there is a set method for every variable in your PreparedStatement by carefully checking your code.
 
Nitin Shivaram
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This most often happens with a precompiled SQL statement and you pass the various variables at runtime. I have come across this error when i call a Java Prepared Statement and i haven't bound all the IN variables.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic