Something

Create or replace procedure TRANSFEREER_SPELER 
(p_bondnr in speler.bondnr%type,
p_stamnr in ploeg.stamnr%type) is
begin
update speler set ploeg = p_stamnr where bondnr = p_bondnr;
COMMIT;
end TRANSFEREER_SPELER ;