    SET SERVEROUTPUT ON
    DECLARE
		v_student_id NUMBER := &amp;sv_student_id;
		v_section_id NUMBER := 89;
		v_final_grade NUMBER;
		v_letter_grade CHAR(1);
    BEGIN
		SELECT final_grade
		INTO v_final_grade
		FROM enrollment
		WHERE student_id = v_student_id
		AND section_id = v_section_id;
		
		CASE -- outer CASE
			WHEN v_final_grade IS NULL THEN
				DBMS_OUTPUT.PUT_LINE (&#39;There is no final grade.&#39;);
			ELSE
				CASE -- inner CASE
					WHEN v_final_grade &gt;= 90 THEN v_letter_grade := &#39;A&#39;;
					WHEN v_final_grade &gt;= 80 THEN v_letter_grade := &#39;B&#39;;
					WHEN v_final_grade &gt;= 70 THEN v_letter_grade := &#39;C&#39;;
					WHEN v_final_grade &gt;= 60 THEN v_letter_grade := &#39;D&#39;;
					ELSE v_letter_grade := &#39;F&#39;;
				END CASE;
				
				-- control resumes here after inner CASE terminates
				DBMS_OUTPUT.PUT_LINE (&#39;Letter grade is: &#39;||v_letter_grade);
		END CASE;
		-- control resumes here after outer CASE terminates
    END;

the above code I have taken from the book *&quot;Oracle PL/SQL by Example, 4th Edition 2009&quot;* my problem is when I enter a `student_id` not present in the table it returns me the following error

&lt;pre&gt;
Error report: ORA-01403: no data found
ORA-06512: at line 7
01403. 00000 -  &quot;no data found&quot;
*Cause:    
*Action:
&lt;/pre&gt;

but according to the book it should have returned a null value and then follow the case flow.

All Ora 01403 Solutions on Gang of Coders

Total of 1 Ora 01403 Solutions

PL/SQL block problem: No data found error