title: Inserting into table
body: <p>I have this table on an Oracle server with this structure:</p>
  
  <pre><code>Create table temp
  (
      input number(10),
      str varchar(24),
  
      constraint L_PK PRIMARY KEY(input, str)
  )
  </code></pre>
  
  <p>I made one alteration on it:</p>
  
  <pre><code>alter table temp add userID number(10);
  </code></pre>
  
  <p>Now I am trying to do an insert:</p>
  
  <pre><code>insert into temp values (9, 7, 'sure.');
  </code></pre>
  
  <p>But I am getting a error saying: </p>
  
  <blockquote>
    <p>ORA-01722: Invalid Number</p>
  </blockquote>
  
  <p>Any ideas? I'm pretty sure its coming from the 'sure' but I can't say for sure.</p>