Szerintetek ez miért nem fut le?
SET SERVEROUTPUT ON;
DECLARE
v_instructor_id NUMBER := &inst_id;
v_course_numb NUMBER;
v_first name instructor.first_name%TYPE;
v_last name instructor.last_name%TYPE;
BEGIN
SELECT COUNT(s.instructor_id), i.first_name, i.last_name
INTO v_course_numb, v_fist_name, v_last_name
FROM section s, instructor i
WHERE s.instructor_id = v_instructor_id;
if v_course_numb >= 3 THEN
DBMS_OUTPUT.PUT_LINE('The instructor ' || v_first_name );
ELSE
DBMS_OUTPUT.PUT_LINE('The instructor ' ');
END IF;
DBMS_OUTPUT.PUT_LINE('Done...');
END;
.
/
ORA-06550: line 4 coloumn 16
PLS-00103 : Encountered the simbol "INSTRUCTOR" when expecting one of the following :
:= , ( @ .....stb...