DELIMITER $$

-- Vorstellung-Package

DROP PROCEDURE IF EXISTS `vrst_pub_add_vorstellung`$$
CREATE PROCEDURE `vrst_pub_add_vorstellung` (p_saalname VARCHAR(50), p_filmname VARCHAR(255), p_beginn DATETIME)
BEGIN
  INSERT INTO Vorstellung (Beginn, fk_Film_ID, fk_Saal_ID) VALUES (p_beginn, film_pub_search_film(p_filmname), saal_pub_search_saal(p_saalname));
END$$



DELIMITER ;