Please can you help me?I am getting the following error.
java.sql.SQLException: [Oracle][ODBC][Ora]ORA-00904: "CUST001": invalid identifier
I am working on a monthly billing system for general stores. I enter the ITEMID and click the button. The ITEMID is stored in a variable and searched for item details from the ITEMS table which are then entered into PURCHASE table along with a previously retrieved CUSTOMERID in this case the customerid is CUST001.