title: PHP Oracle Multi table insert as one block
body: <p>On Linux, PHP 4.3 and Oracle 10g, I am allowing candidates to apply online for jobs. At apply button I have write insert queries like this</p>
  
  <pre><code>$sql1 = insert into job_table (…) values (…);  //inserting over 20 values
  $stmt1=OCIParse($conn,$sql1);
  OCIExecute($stmt1);
  
  $sql2 = insert into personal_info_table (…) values (…);  //inserting over 50 values
  $stmt2=OCIParse($conn,$sql2);
  OCIExecute($stmt2);
  
  $sql3 = insert into qualification_info_table (…) values (…);  //inserting over 20 values
  $stmt3=OCIParse($conn,$sql3);
  OCIExecute($stmt3);
  </code></pre>
  
  <p>Problem is that due to unknown reasons, sometimes all insert queries does not run thus I cannot able to track particular information in all tables.
  Is there any way that ensures all insert commands MUST runs? Or rollback the entire transaction if any insert statement does not run?
  Any help in this regard is greatly appreciated.</p>