title: SQL Insert with ORA-00911: invalid character
body: <p>I am adding some new records to my table "flight" in Oracle database. However, I encountered a error which is called in valid character. May anyone help me to figure the error out of my insertion statement.</p>
  
  <p>My Table creation statement is as follow.</p>
  
  <pre><code> create table flight(
         FlightID integer NOT NULL,
         Airline char(20) NOT NULL,
         DepartCity char(20) NOT NULL,
         ArrivalCity char(20) NOT NULL,
         DepartTime timestamp NOT NULL,
         ArrivalTime timestamp NOT NULL,
         Class2Price integer NOT NULL,
         Class1Price integer NOT NULL,
         Class2Seats integer NOT NULL,
         Class1Seats integer NOT NULL,
         primary key (FlightID));
  </code></pre>
  
  <p>My insertion is as follow</p>
  
  <pre><code>insert into flight(FlightID, Airline, DepartCity, ArrivalCity, DepartTime, ArrivalTime,         Class2Price, Class1Price, Class2Seats, Class1Seats)
  Values(2,'Pacific Airlines','Taipei','Osaka',to_timestamp('2014-12-01 08:15','yyyy-mm-dd HH24:MI'),to_timestamp('2014-12-01 13:15','yyyy-mm-dd HH24:MI'),4500,6000,2,6);
  </code></pre>
  
  <p>My JDBC JavaCode is as follow</p>
  
  <pre><code>stmt.execute("insert into flight(FlightID, Airline, DepartCity, ArrivalCity, DepartTime, ArrivalTime, Class2Price, Class1Price, Class2Seats, Class1Seats)"
                  +"values("+ values+")");
  </code></pre>
  
  <p>where values is</p>
  
  <pre><code>   values =2,'Pacific Airlines','Taipei','Osaka',to_timestamp('2014-12-01 08:15','yyyy-mm-dd HH24:MI'),to_timestamp('2014-12-01 13:15','yyyy-mm-dd HH24:MI'),4500,6000,2,6
  </code></pre>
  
  <p>The error code are as follow</p>
  
  <pre><code> 3月 15, 2014 12:45:06 上午 database.application.DatabaseApplication load_data
  </code></pre>
  
  <p>SEVERE: null
  java.sql.SQLSyntaxErrorException: ORA-00911: invalid character</p>
  
  <pre><code>at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
  at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
  at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
  at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:298)
  at database.application.DatabaseApplication.load_data(DatabaseApplication.java:282)
  at database.application.DatabaseApplication.Data_mani_menu(DatabaseApplication.java:106)
  at database.application.DatabaseApplication.main_menu(DatabaseApplication.java:55)
  at database.application.DatabaseApplication.main(DatabaseApplication.java:28)
  </code></pre>