create or replace PROCEDURE ADDCOURSEANDLANGUAGE 
(
  COURSENAME IN VARCHAR2 
, TEACHERID IN NUMBER 
, LANGUAGENAME IN VARCHAR2 
) AS 
 languageId int;
BEGIN
   select LANGUAGE.Id into languageId from language where language.LANGUAGE = languagename;
     insert into course(name, teacherid, languageid) values (coursename, teacherid, languageid);
   EXCEPTION
     WHEN NO_DATA_FOUND THEN begin
       insert into language (language) values (languagename);
       select LANGUAGE.Id into languageId from language where language.LANGUAGE = languagename;
         insert into course(name, teacherid, languageid) values (coursename, teacherid, languageid);
    end;
END ADDCOURSEANDLANGUAGE;