title: ORA-01858: a non-numeric character was found where a numeric was expected? Even when the values are numbers?
body: <p>This is the table </p>
  
  <pre><code>    CREATE TABLE Employee
      (EmpID number(5) primary key,
      SIN Number(9) Not null,
      LastName Varchar2(25) Not null,
      FirstName Varchar2(25),
      Street Varchar2(30),
      City Varchar2(25),
      Province Char(2),
      PostalCode Varchar2(7),
      JobCode Number(4) Not null,
      Foreign Key(JobCode) REFERENCES Job,
      IncomeTax Char(1),
      BirthDate Date,
      HireDate Date,
      JobCodeDate Date)
      TABLESPACE users;
  </code></pre>
  
  <p>This is the line I am trying to insert, there is only three numeric values and all of them are numbers as far as I can see. </p>
  
  <pre><code>INSERT INTO Employee VALUES(97319,516303417,'Novak','Gerry','6803 Park Ave.','Moose Jaw','SK','S6H 1X7',3000,'N','24-Aug-86','07-Jul-03','07-Jul-03');
  
  ERROR at line 1:
  ORA-01858: a non-numeric character was found where a numeric was expected
  </code></pre>