zoekWinkelsInProvincie.sql

create or replace 
PROCEDURE zoekWinkelsInProvincie (
  provincie IN VARCHAR,
  stores OUT SYS_REFCURSOR
)
IS
BEGIN
  OPEN stores FOR
    SELECT *
    FROM winkel w
    JOIN postcode p ON p.postcode = w.postcode
    WHERE p.province = provincie;
END;
/