title: SQL Error: ORA-02291: integrity constraint
body: <p>I am creating a database that is trying to access values from a foreign key. I have created two following tables </p>
  
  <pre><code>CREATE TABLE Component(
      ComponentID varchar2(9) PRIMARY KEY
      , TypeID varchar2(9) REFERENCES TypeComponent(TypeComponentID)
  )
  
  INSERT INTO Component VALUES(192359823,785404309)
  INSERT INTO Component VALUES(192359347,785404574)
  INSERT INTO Component VALUES(192359467,785404769)
  INSERT INTO Component VALUES(192359845,785404867)
  INSERT INTO Component VALUES(192359303,785404201)
  INSERT INTO Component VALUES(192359942,785404675)
  
  
  CREATE TABLE TypeComponent (
      TypeComponentID varchar2(9) PRIMARY KEY
      , Type_Description varchar2(30) CONSTRAINT Type_Description 
          CHECK(Type_Description IN('Strap', 'Buckle', 'Stud')) NOT NULL
  )
  
  INSERT INTO TypeComponent VALUES(785404309, 'Strap')
  INSERT INTO TypeComponent VALUES(785404574, 'Stud')
  INSERT INTO TypeComponent VALUES(785404769, 'Buckle')
  INSERT INTO TypeComponent VALUES(785404867, 'Strap')
  INSERT INTO TypeComponent VALUES(785404201, 'Buckle')
  INSERT INTO TypeComponent VALUES(785404675, 'Stud')
  </code></pre>
  
  <p>These are the two tables. <code>Component</code> and <code>TypeComponent</code>. <code>Component</code> is the parent entity to <code>TypeComponent</code>, and I am trying to run the following INSERT statement:</p>
  
  <pre><code>INSERT INTO Component VALUES(192359823,785404309)
  </code></pre>
  
  <p>but it is giving me the error </p>
  
  <p>This is the session that I have so far in Oracle SQL dev </p>