title: How to get the message of RaiseError of a procedure in another procedure
body: <p>I have two procedures <code>PROC_A</code> and <code>PROC_B</code>.</p>
  
  <p>In both procedure transaction are managed.</p>
  
  <p><code>PROC_B</code> throws an error by calling <code>RAISEERROR</code> and passes a message in certain condition </p>
  
  <pre><code>RAISERROR ('Initiator is Inactive', 16, 1, 'Approve Transaction'); 
  </code></pre>
  
  <p>I am executing (calling) <code>PROC_B</code> in <code>PROC_A</code>. Now I want to get the error message thrown by <code>PROC_B</code> in <code>PROC_A</code>.</p>
  
  <p>How can I do that?</p>