Posted By

wh0emPah on 04/02/10


Tagged


Versions (?)

zerfz


 / Published in: PL/SQL
 

  1. CREATE OR REPLACE PROCEDURE P4_4_VERWIJDER_MEDEWERKER(
  2. MED_ID IN S_EMP.ID%TYPE)
  3. E_CHILDREN_FOUND EXCEPTION;
  4. PRAGMA EXCEPTION_INIT (E_CHILDREN_FOUND, - 2292);
  5. DELETE FROM S_EMP
  6. WHERE ID = MED_ID;
  7.  
  8. WHEN E_CHILDREN_FOUND THEN
  9. DBMS_OUTPUT.PUT_LINE ('Employee has children!');
  10. RAISE_APPLICATION_ERROR( -20000, 'Onbekende fout opgetreden');
  11. END P4_4_VERWIJDER_MEDEWERKER;

Report this snippet  

You need to login to post a comment.