title: PL/SQL Exceptions on Update/Delete of non-existing row
body: <p>I am learning PL/SQL these days and currently working with Procedures and exceptions using oracle HR schema. </p>
  
  <p>Here is my simple procedure. </p>
  
  <pre><code>create or replace
  PROCEDURE DEL_JOB
  (p_jobid jobs.job_id%TYPE)
  AS 
  sqle NUMBER; 
  sqlm VARCHAR2(300);
  BEGIN
  DELETE FROM JOBS 
  WHERE JOB_ID = UPPER(p_jobid);
  IF SQL%NOTFOUND THEN
    DBMS_OUTPUT.PUT_LINE('No such record');
  END IF;
  EXCEPTION
   WHEN OTHERS THEN
    sqle := SQLCODE;
    sqlm := SQLERRM;
    DBMS_OUTPUT.PUT_LINE('There is no job with this id that could be deleted');
    DBMS_OUTPUT.PUT_LINE('Error Code ='||sqle||' Error message =' ||sqlm);
  END;
  </code></pre>
  
  <p>When I execute this procedure the output is </p>
  
  <pre><code>  No such record
    PL/SQL procedure successfully complete. 
  </code></pre>
  
  <p>However, according to the Oracle PDF it should throw an exception and I should really get the message I entered in the exception. </p>
  
  <p>Same thing happened with the Update on non existing record. 
  Please advise. Thanks</p>