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

Error occurred during batching: ORA-00933: SQL command not properly ended

 
priya Anand
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
I am executing following code in my application and I am getting an error as,
: java.sql.BatchUpdateException:
error occurred during batching: ORA-00933: SQL command not properly ended


Any help is highly appreciated.

Thanks and Regards,
Priya
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 35976
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Two debugging tips that will greatly narrow down your question:
1) Which is failing stmt or stmt1?
2) What is the literal String that you are passing in (after all the concatenation is done), does it work at command line Oracle?
 
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!