title: Violated - parent key not found 02291. 00000 - "integrity constraint
body: <p>Hi I am developing a database in Oracle SQL dev, that is trying to access foriegn keys from another table. I am currently working on the ItemOrdered table which I've created with the following CREATE statement </p>
  
  <pre><code>CREATE TABLE ItemOrdered(OrderID varchar2(9) REFERENCES Ords(OrderID),
  BeltID varchar2(9) REFERENCES BeltID(BeltID), 
  Quantity varchar(4) NOT NULL,
  PRIMARY KEY(OrderID, BeltID))
  </code></pre>
  
  <p>As you can See I have the following foriegn keys Ords and BeltID. </p>
  
  <p>Now when I try to run the following statement </p>
  
  <pre><code>INSERT INTO ItemOrdered VALUES(401565981,234489212,'2')
  </code></pre>
  
  <p>It gives me the following error </p>
  
  <blockquote>
    <p>violated - parent key not found
    02291. 00000 - "integrity constraint (%s.%s) violated - parent key not found"</p>
  </blockquote>
  
  <p>I have provided my Ords CREATE statement if its needed </p>
  
  <pre><code>  CREATE TABLE Ords(OrderID varchar2(9) PRIMARY KEY, 
  CustomerID varchar(9) REFERENCES Customers(CustomerID), 
      Expected_Delivery_Date date DEFAULT sysdate NOT NULL, 
  Actual_Delivery_Date date DEFAULT sysdate NOT NULL, 
      Payment_Due_Date date DEFAULT sysdate NOT NULL, 
  Order_Date date DEFAULT sysdate NOT NULL, Price Varchar(10), 
      Order_Placed varchar2(1) CONSTRAINT OrderPlaced 
  CHECK(Order_Placed IN('Y','N')) NOT NULL, 
  Order_Confirmed varchar2(1)
      CONSTRAINT Order_Confirmed CHECK(Order_Confirmed IN('Y','N')) NOT NULL, 
  Order_Completed varchar2(1) CONSTRAINT Order_Completed
      CHECK(Order_Completed IN('Y','N')) NOT NULL)
  </code></pre>
  
  <p>And I have also provided my BeltID CREATE statement </p>
  
  <pre><code>    CREATE TABLE BeltID(BeltID varchar2(9) PRIMARY KEY, 
  BeltLengthID varchar2(9) REFERENCES BeltLength(BeltLengthID), 
      ColourID varchar2(9) REFERENCES Colour(ColourID), 
  DesignID varchar2(9) REFERENCES Design(DesignID),ComponentID varchar2(9) REFERENCES Component(ComponentID))
  </code></pre>
  
  <p>I don't seem to quite understand why I am getting this error. Is there an clear explanation why?</p>
  
  <p>Here is the http link of what I am trying to do. 
  <a href="http://i.stack.imgur.com/pUflg.jpg" rel="nofollow">link text</a></p>