oracle-databaseora-00911

ORA-00911: invalid character Eclipse


java.sql.SQLSyntaxErrorException: ORA-00911: invalid character. I cant see any problem but eclipse get error ora-911

        public void create(String NAME, String DOGUM, String ADRES, String EMAIL, String PASSWORD) throws SQLException {

        String sql = "INSERT INTO UYELER (UYE_ID, UYE_ADSOYAD, UYE_DOGUM, UYE_ADRES, UYE_EMAIL, UYE_PASSWORD) VALUES (UYELER_SEQ.NEXTVAL,?,?,?,?,?)";

        PreparedStatement stmt = conn.prepareStatement(sql);

        stmt.setString(1, NAME);
        stmt.setString(2, DOGUM);
        stmt.setString(3, ADRES);
        stmt.setString(4, EMAIL);
        stmt.setString(5, PASSWORD);

        stmt.executeUpdate();
        stmt.close();

    } 

Solution

  • The problem seems about date format. If your dogum column is date so you cant set it as string. If it is string so check your data. You can set it manually for test like "20180328". If it dont give any error the problem is on your data