title: PL/SQL error: exact fetch returns more than requested number of rows ORA-06512:
body: <p>I am trying to enter a student id from the students table to get the decision of whether they passed or failed from the module_grades table but i keep getting that error when i enter the student id can anyone help, thanks
  Here is my code:</p>
  
  <pre><code>set serverouput on
  DECLARE
  Student Students.Sid%type:='&amp;sid';
  decision MODULE_GRADES.MDECISION%type;
  BEGIN
  SELECT MDECISION INTO decision FROM MODULE_GRADES
  WHERE Sid = Student;
  IF
  (decision = 'Pass')
  Then
  DBMS_OUTPUT.PUT_LINE('You got'||Decision||' congratulations');
  END IF;
  END;
  </code></pre>