title: Why My transaction code is not working in oracle
body: <pre><code>being try
  being transaction 
  insert into branch values('Dholanwal','Faisalabad',1200);
  insert into account values('l-111','Dholanwal',1200);
  commit transaction
  end try
  being catch
  if (@@ERROR &gt;0)
  
  rollback transaction
  end catch
  </code></pre>
  
  <blockquote>
    <p>Error starting at line : 4 in command -
    insert into account values('l-111','Dholanwal',1200)
    Error report -
    ORA-00001: unique constraint (mehran.SYS_C0012129) violated</p>
    
    <p>Unknown Command: commit transaction
    end try
    being catch
    if (@@ERROR >0)</p>
  </blockquote>
  
  <p>rollback transaction
  end catch</p>