title: PLS-00382: expression is of wrong type in Cursor
body: <pre><code>DECLARE
  
  A_NAME STUDENTS_1.NAME%TYPE;
  B_NAME STUDENTS_1.NAME%TYPE;
  C_NAME STUDENTS_1.NAME%TYPE;
  GRADE_ST STUDENTS_1.GRADE%TYPE;
  
  
  CURSOR A IS SELECT NAME FROM STUDENTS_1 WHERE REGEXP_LIKE(GRADE,'(A)','i');
  CURSOR B IS SELECT NAME FROM STUDENTS_1 WHERE REGEXP_LIKE(GRADE,'(B)','i');
  CURSOR C IS SELECT NAME FROM STUDENTS_1 WHERE REGEXP_LIKE(GRADE,'(C)','i');
  
  
  BEGIN
  GRADE_ST:= &amp;CHOICE;
  
  
  IF (GRADE_ST='A') THEN
  
  OPEN A;
  LOOP
  
  FETCH A INTO A_NAME;
  
  EXIT WHEN A%NOTFOUND;
  
  INSERT INTO SCHOLARSHIP_A VALUES(A_NAME);
  
  END LOOP;
  CLOSE A;
  
  
  ELSIF (GRADE_ST='B') THEN 
  
  OPEN B;
  LOOP
  
  FETCH B INTO B_NAME;
  
  EXIT WHEN B%NOTFOUND;
  
  INSERT INTO SCHOLARSHIP_B VALUES(B_NAME);
  
  END LOOP;
  CLOSE B;
  
  
  ELSE
  
  OPEN C;
  LOOP
  
  FETCH C INTO C_NAME;
  
  EXIT WHEN C%NOTFOUND;
  
  INSERT INTO SCHOLARSHIP_C VALUES(C_NAME);
  
  END LOOP;
  
  CLOSE C;
  
  
  
  END IF;
  
  END;
  
  /
  </code></pre>
  
  <p>I'm making  three different scholarship tables with grades A,B,C if i user input values rather than grades i'm getting the solution but i don't want to give values as user input i want user input should be grades 
  like if i input A i should get all names with grade A from the table 
  but i'm ending up with this error</p>