select 'x' into l_already_took_it
from subjects
where student_id = :student_id
  and subject_id = :subject_id;

if l_already_took_it is not null then
   message('Can not take the same subject twice');
   raise form_trigger_failure;
end if;