title: c# ora-02291 error
body: <p>This is an odd one...
  I have two tables tableA and tableB
  tableB has a foreign key in tableA.</p>
  
  <p>I have 2 sprocs, one inserts to tableA, the other to tableB.</p>
  
  <p>using odp.net I run the first sproc, inserting a record into tableA. I can then open SQLPlus and select this record</p>
  
  <p>I then run the second sproc, inserting into tableB.
  <strong>It fails with "ora-02291-integrity-constraint-violated-parent-key-not-found"</strong></p>
  
  <p>I have double, triple, quadruple checked for typos etc... nothing.</p>
  
  <p>To make things even more odd when I do this same operation manually in SQLPlus, with the same sprocs, it works without a problem.</p>
  
  <p>This is killing me 12+ hours looking for something I know has to be simple.
  Here are the sprocs.</p>
  
  <p><strong>SPROCA</strong></p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE genData_TestTrackerSegment
    (
      INTX_ID IN IntxSegment.IntxID%TYPE,
      siteid IN INT
    )
  AS
  BEGIN
  INSERT INTO INTXSEGMENT(INTXID,INTXTYPEID,VERSION,ISPRIVATE,
  SEGMENTTYPE,STARTDATETIME,INTXDIRECTION,SITEID)
  VALUES(INTX_ID,1,1,0,1,SYSDATE,1,siteid);
  COMMIT;
  END;
  </code></pre>
  
  <p><strong>SPROCB</strong></p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE genData_TestTrackerPart
    (
      INTX_ID IN IntxSegment.IntxID%TYPE,
      INTX_PART_ID IN INTX_PARTICIPANT.INTX_PART_ID%TYPE,
      INDIVID IN INDIVIDUAL.INDIVID%TYPE,
      CALLID IN INTX_PARTICIPANT.CALLIDKEY%TYPE
    )AS
  BEGIN
  INSERT INTO
  INTX_PARTICIPANT(INTXID,INTX_PART_ID,INDIVID,ROLE,
  CALLIDKEY,RECORDED,VERSION,STARTDATETIME)
  VALUES(INTX_ID,INTX_PART_ID,INDIVID,1,CALLID,1,1,SYSDATE);
  COMMIT;
  END;
  </code></pre>