'java.sql.SQLSyntaxErrorException: ORA-00904: "INFO": invalid identifier

I'm trying to update a Table in Oracle DB. When i was using this query it was working fine

UPDATE ITEM_TABLE SET ITEM_ID = ?, DESCRIPTION = ? WHERE M_ID = ?

Now, I've added new column 'INFO' to the table of VARCHAR2(20), and I'm getting the following error:

bad SQL grammar [UPDATE ITEM_TABLE SET ITEM_ID = ?, INFO = ?, DESCRIPTION = ? WHERE M_ID = ?]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "INFO": invalid identifier

how to fix this?

sqloraclejdbc


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions