CREATE OR REPLACE PROCEDURE TEAM_QUIT_sp (
p_memberID    IN INTEGER
)
AS
lv_teamID_num     CR_TEAM.TEAM_ID%TYPE;
lv_leaderID_num   CR_TEAM.MEMBER_ID%TYPE;
lv_memberID_num   CR_MEMBER.MEMBER_ID%TYPE;
ex_leader         EXCEPTION;

BEGIN
  IF p_memberID = lv_teamID_num
    THEN
    DELETE FROM CR_TEAM
    WHERE lv_memberID_num = p_memberID;
    DBMS_OUTPUT.PUT_LINE(lv_memberID_num || 'You have succsessfully left the team');

  ELSE
  RAISE ex_leader;
  END IF;

EXCEPTION
  WHEN ex_leader
  THEN DBMS_OUTPUT.PUT_LINE('You must select the new leader before leaving');
  ROLLBACK;

  WHEN NO_DATA_FOUND THEN
  DBMS_OUTPUT.PUT_LINE('No data found:     ' || p_memberID);


END TEAM_QUIT_sp;