blablabla

CREATE OR REPLACE
PROCEDURE P1_1_VOEG_KLANT_TOE 
(
  p_id      IN S_CUSTOMER.ID%TYPE,
  p_name    IN S_CUSTOMER.NAME%TYPE,
  p_phone   IN S_CUSTOMER.PHONE%TYPE,
  p_address IN S_CUSTOMER.ADDRESS%TYPE,
  p_city    IN S_CUSTOMER.CITY%TYPE,
  p_state   IN S_CUSTOMER.STATE%TYPE,
  p_country IN S_CUSTOMER.COUNTRY%TYPE,
  p_zipcode IN S_CUSTOMER.ZIP_CODE%TYPE
)
AS
 
BEGIN
  INSERT INTO S_CUSTOMER(ID, NAME, PHONE, address, city, state, country,ZIP_CODE)
  VALUES (p_id,p_name,P_PHONE,P_ADDRESS,P_CITY,P_STATE,P_COUNTRY,P_ZIPCODE);
  COMMIT;
END P1_1_VOEG_KLANT_TOE;