title: Why did I get the ""exact fetch returns more than requested number of rows" when I use cursor already?
body: <p>I am using the cursor to write the following codes, so that the cursor can pick up multiple lines. However, it still gives me the error message "exact fetch returns more than requested number of rows". Isn't that the cursor will retrieve data one line at a time. Why is this message still showing?</p>
  
  <pre><code> create or replace trigger e
      before delete on enrollment
      for each row
      declare 
         get_tid scorest.tid%type;
         get_ferm scorest.ferm%type;
         get_sect scorest.sect%type;
         get_name scorest.name%type;
         get_score scorest.score%type;
         cursor findenrolls(atid in scorest.tid%type, 
                            aferm in scorest.ferm%type, 
                            asect in scorest.sect%type)
                            is select * from scorest;
      begin 
         for findenrolls_rec in findenrolls(:old.tid, :old.ferm, :old.sect) loop      
            select tid, ferm, sect, name, score
            into get_tid, get_ferm, get_sect, get_name, get_score
            from scorest
            where scorest.tid=:old.tid
            and scorest.ferm=:old.ferm
            and scorest.sect=:old.sect;
  
        insert into deleted_scores values (get_tid, get_ferm, get_sect, get_name, get_score);
  
        delete from scorest
        where tid=get_tid
        and ferm=get_ferm
        and sect=get_sect
        and name=get_name;
     end loop;
  end;
  </code></pre>