-- New member procedure
alter session set current_schema = DT2113FCA;
-- PROCEDURE for Entering a new Member
CREATE OR REPLACE PROCEDURE enterNewMember(
-- Declaring passed in variables
  v_memID IN members.mem_id%TYPE, -- Passed in by Procedure
  v_Sport IN members.sport%TYPE, -- Passed in by Procedure
  v_memName IN members.m_name%TYPE,  -- Passed in by Procedure
  v_memAddr IN members.address%TYPE, -- Passed in by Procedure
  v_memPho IN members.phone_no%TYPE, -- Passed in by Procedure
  v_memType IN members.membership_type%TYPE, -- Passed in by Procedure
  v_gradeNum IN members.grade_num%TYPE, -- Passed in by Procedure
  v_memFeesP IN members.fees_paid%TYPE, -- Passed in by Procedure
  v_memFeesD IN members.fees_due%TYPE -- Passed in by Procedure
) is

BEGIN
  -- Make this better
  INSERT INTO MEMBERS(mem_id, sport, m_name, address, phone_no, membership_type,
  grade_num, fees_paid, fees_due) VALUES (v_memID, v_Sport, v_memName, v_memAddr, v_memPho, v_memType,
  v_gradeNum, v_memFeesP, v_memFeesD);
  commit; -- committing my transaction
  EXCEPTION
  WHEN NO_DATA_FOUND THEN
  DMBS_OUTPUT.PUT_LINE('ERROR');
END enterNewMember;