Advertisement
catalin_stefann11

Untitled

May 21st, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.35 KB | None | 0 0
  1. ACCEPT id_m PROMPT 'Introduceti id-ul membrului'
  2. DECLARE
  3. invalid_id EXCEPTION;
  4. id_mem membrii.id_membru%TYPE := &id_m;
  5.  
  6. BEGIN
  7. UPDATE membrii
  8. SET nr_telefon = NULL
  9. WHERE id_membru = id_mem;
  10.  
  11. IF SQL%NOTFOUND THEN
  12. RAISE invalid_id;
  13. END IF;
  14.  
  15. EXCEPTION
  16. WHEN invalid_id THEN
  17. DBMS_OUTPUT.PUT_LINE('Nu exista membrul cu id-ul: ' || id_mem);
  18. END;
  19. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement