Why do I get invalid number from this query?
<p>I get "ORA-01722: invalid number" from this query:</p>

<pre><code>INSERT INTO OLD_MATCHES 
(ID, LEAGUE, WEEK, MATCH_DATE, HOME, AWAY, HOME_GOALS, AWAY_GOALS, HOME_BET, DRAW_BET, AWAY_BET, LEAGUE_SEASON)
VALUES
(OLD_MATCHES_SEQ.NEXTVAL, 240, 11, '26-02-2016', 'Chelsea', 'Arsenal', 3, 0, 2, 3, 4, 'Premier league');
</code></pre>

<p>I looked at this explanation at Oracle FAQ:</p>

<p>An ORA-01722 ("invalid number") error occurs when an attempt is made to convert a character string into a number, and the string cannot be converted into a valid number. Valid numbers contain the digits '0' through '9', with possibly one decimal point, a sign (+ or -) at the beginning or end of the string, or an 'E' or 'e' (if it is a floating point number in scientific notation). All other characters are forbidden. </p>

<p>But it didn't make sense to me. </p>

<p>sequence script:</p>

<pre><code>CREATE SEQUENCE FOOTBALL.OLD_MATCHES_SEQ
  START WITH 12
  MAXVALUE 999999
  MINVALUE 1
  NOCYCLE
  NOCACHE
  NOORDER;
</code></pre>

<p>Table script:</p>

<pre><code>CREATE TABLE FOOTBALL.OLD_MATCHES
(
  ID             NUMBER                         NOT NULL,
  LEAGUE         NUMBER,
  WEEK           NUMBER,
  MATCH_DATE     DATE,
  HOME           VARCHAR2(100 BYTE),
  AWAY           VARCHAR2(100 BYTE),
  HOME_GOALS     NUMBER,
  AWAY_GOALS     NUMBER,
  HOME_BET       NUMBER(5,2),
  AWAY_BET       NUMBER(5,2),
  DRAW_BET       NUMBER(5,2),
  LEAGUE_SEASON  NUMBER
)
</code></pre>