title: Data Consistency within the same Transaction
body: <p>Any one can help on the below issue.
  Thanks in advance.</p>
  
  <p>I am updating a Table ACC_STATUS for Id 100</p>
  
  <p>Current Value of Status Column is 0.</p>
  
  <pre><code>UPDATE ACC_STATUS
  SET STATUS = 1
  WHERE ID = 100;
  </code></pre>
  
  <p>After Update I am calling a Procedure, <code>pro_do_other_things</code>, which is in another Schema.</p>
  
  <p>There is a SELECT From Table ACC_STATUS in this Procedure - pro_do_other_things. The result is not showing the updated value always. In some cases it shows the New Updated Value and in some other cases Old Value.</p>
  
  <p>Please not that both Update Statement and Call to Procedure are happening in the Same Transaction as below.</p>
  
  <pre><code>BEGIN
  
     UPDATE ACC_STATUS
     SET STATUS = 1
     WHERE ID = 100;
  
     OTHER_SCHEMA.pro_do_other_things;
  
   COMMIT;
  
  EXCEPTION
  WHEN OTHERS THEN
     ROLLBACK;
  
  END;
  </code></pre>
  
  <p>Could anyone please explain why it is happening so?</p>