title: Stored procedure exception handling
body: <pre><code>SQL&gt;  DECLARE
  2    TotalUpd   NUMBER(36) := 0;
  3  BEGIN
  4   dbms_output.put_line ('Job Start time............... : ' || to_char(SYSDATE, '             hh24:mi:ss'));
  5   UPDATE Asset SET _status = 'PROGRESS' WHERE status is null;
  6   TotalUpd := SQL%ROWCOUNT;
  7   dbms_output.put_line('Total Records Updated. : ' || TotalUpd);
  8    COMMIT;
  9   EXCEPTION
  10   WHEN NO_DATA_FOUND THEN
  11  dbms_output.put_line ('No more data to update.');
  12  WHEN OTHERS THEN
  13  dbms_output.put_line ('Error while status as SUCCESS ');
  14  END ;
  15  /
  </code></pre>
  
  <p>The result for the above procedure is
      Job Start time............... : 04:41:41
      Total Records Updated. : 0</p>
  
  <p>But my expected result is "No more row to be updated" must be printed,since i have truncated the table Asset.Please tell where I went wrong in this.</p>