create or replace PROCEDURE ADDCOURSEANDLANGUAGE2(
    COURSE_NAME   IN VARCHAR2 ,
    TEACHER_ID    IN NUMBER ,
    LANGUAGE_NAME IN VARCHAR2 )
AS
  how_many          INT;
  language_id_found INT;
BEGIN
  SELECT COUNT(*) INTO how_many FROM language WHERE language.language = language_name;
  IF how_many = 0 THEN
    INSERT INTO language (language) VALUES (language_name);
  END IF;
  SELECT language.id INTO language_id_found FROM language WHERE language.language = LANGUAGE_NAME;
  INSERT INTO course (name, teacherid,languageid)
    VALUES (course_name, teacher_id, language_id_found);
END ADDCOURSEANDLANGUAGE2;