title: PL/SQL exception handling with procedures
body: <pre><code>create or replace procedure UPD_DEP 
      (dd_name in dept.dname%type, --department which has to be updated
      d_name in dept.dname%type)   --name to which the first parameter has to be updated 
  is 
  abc_exception exception;
  begin
  if (dname&lt;&gt;dd_name) THEN
    raise abc_exception; 
  end if;
  update dept
  set dname=d_name
  where dname=dd_name;  
  commit;
  EXCEPTION
  WHEN  abc_exception THEN
  dbms_output.put_line('department not present which u want to be updated');
  end upd_dep;
  </code></pre>
  
  <p>Error at line 9: PL/SQL: Statement ignored</p>
  
  <ul>
  <li>7  if (dname&lt;>dd_name) THEN   (line 7)</li>
  <li>8    raise abc_exception; (line 8)</li>
  <li>9  end if; (line 9)</li>
  <li>10  update dept (line 10)</li>
  <li>11  set dname=d_name (line 11)</li>
  </ul>