Oracle ORA-00933: SQL command not properly ended?

user3543466 picture user3543466 · Mar 11, 2014 · Viewed 33.1k times · Source

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>   

Answer

124 picture 124 · Mar 11, 2014

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#