|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Unknown Command Erorr???
Below is my code.
This is the error i get and i cant figure it out: SP2-0042: unknown command ")" - rest of line ignored. INSERT INTO MajorGrades (dept, grade, count) Does anyone know what I am doing wrong here? thanks for any help. CLEAR SCREEN; --DROP TABLE MajorGrades; CREATE TABLE MajorGrades( dept CHAR(3), grade CHAR(1), count NUMBER ); DECLARE v_FirstRead BOOLEAN := TRUE; v_Dept CHAR(3); v_temp CHAR(1); v_CurrGrade CHAR(1); v_Count NUMBER :=0; CURSOR c_MajorGrades IS SELECT department FROM registered_students ORDER BY 1; BEGIN FOR v_CurrGrade IN c_MajorGrades LOOP IF c_MajorGrades%NOTFOUND THEN IF NOT (v_FirstRead) THEN INSERT INTO MajorGrades (dept, grade, count) VALUES (v_Dept, v_CurrGrade, v_Count); END IF; END IF; IF (v_FirstRead) = TRUE THEN v_CurrGrade := v_temp; v_FirstRead := FALSE; END IF; IF v_CurrGrade = v_temp THEN v_Count := v_Count +1; ELSE INSERT INTO MajorGrades (dept, grade, count) VALUES (v_Dept, v_CurrGrade, v_Count); v_CurrGrade := v_temp; v_Count := 1; END IF; END LOOP; END; / |
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Unknown Command Erorr??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|