Oracle ORA-00933: SQL command not properly ended?
33,153
Solution 1
Please put ,
between your columns of Set
Clause like:
update rating set rating_title=#rating_title#, rating_cont=#rating_cont#
where mem_id=#mem_id# and rating_code=#rating_code#
Solution 2
In Oracle, string literals are denoted by single quotes ('
). So, if you plan to use literals:
UPDATE rating
SET rating_title='rating_title', rating_cont='rating_cont'
WHERE mem_id='mem_id' AND rating_code='rating_code'
Author by
Admin
Updated on July 09, 2022Comments
-
Admin almost 2 years
I keep getting this error.
How do I solve this problem?Error:
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
Code:
<update id="updateProc" parameterClass="rating"> update rating set rating_title=#rating_title# rating_cont=#rating_cont# where mem_id=#mem_id# and rating_code=#rating_code# </update>