MyBatis update annotation failed - ORACLE ERROR ORA-00933

31 Views Asked by At

In a classic spring boot application I've this query in Mapper

@Update("UPDATE MY_TABLE SET STATUS_CODE=#{status} WHERE ID_DOC=#{idDoc};")
void updateStatus(@Param("status") final String status,@Param("idDoc") final BigDecimal idDoc);

When I execute method ORA-00933 is returned.

The query works fine in SQLPLUS

What's wrong?

0

There are 0 best solutions below