sql - Keep getting error: PLS-00103: Encountered the symbol "CREATE" - Stack Overflow

admin管理员组

文章数量:1332339

I get the following error in Oracle SQL Developer

PLS-00103: Encountered the symbol "CREATE"

CREATE OR REPLACE PROCEDURE EnrollStudent(
     p_StudentID IN INT,  
    p_CourseID IN INT   
) IS

    v_student_skill INT;
    v_course_skill INT;
    v_enrolled_count INT;
    
BEGIN
    SELECT skill INTO v_student_skill
    FROM A1_Student
    WHERE StudentID = p_StudentID;

    SELECT skill INTO v_course_skill
    FROM A1_Course
    WHERE CourseID = p_CourseID;

    IF v_student_skill < v_course_skill THEN
        RAISE_APPLICATION_ERROR(-20001, 'Student skill level is not sufficient for this course.');
    END IF;

    SELECT COUNT(*) INTO v_enrolled_count
    FROM A1_Enrollment
    WHERE StudentID = p_StudentID AND CourseID = p_CourseID;

    IF v_enrolled_count > 0 THEN
        RAISE_APPLICATION_ERROR(-20002, 'Student is already enrolled in this course.');
    END IF;

    INSERT INTO A1_Enrollment (StudentID, CourseID)
    VALUES (p_StudentID, p_CourseID);

    COMMIT;
    DBMS_OUTPUT.PUT_LINE('Student successfully enrolled in the course.');
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('Student or Course not found.');
    WHEN OTHERS THEN
        
        ROLLBACK;
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
END EnrollStudent;
/

Not entirely sure why this error is popping up, any help would be greatly appreciated.

I get the following error in Oracle SQL Developer

PLS-00103: Encountered the symbol "CREATE"

CREATE OR REPLACE PROCEDURE EnrollStudent(
     p_StudentID IN INT,  
    p_CourseID IN INT   
) IS

    v_student_skill INT;
    v_course_skill INT;
    v_enrolled_count INT;
    
BEGIN
    SELECT skill INTO v_student_skill
    FROM A1_Student
    WHERE StudentID = p_StudentID;

    SELECT skill INTO v_course_skill
    FROM A1_Course
    WHERE CourseID = p_CourseID;

    IF v_student_skill < v_course_skill THEN
        RAISE_APPLICATION_ERROR(-20001, 'Student skill level is not sufficient for this course.');
    END IF;

    SELECT COUNT(*) INTO v_enrolled_count
    FROM A1_Enrollment
    WHERE StudentID = p_StudentID AND CourseID = p_CourseID;

    IF v_enrolled_count > 0 THEN
        RAISE_APPLICATION_ERROR(-20002, 'Student is already enrolled in this course.');
    END IF;

    INSERT INTO A1_Enrollment (StudentID, CourseID)
    VALUES (p_StudentID, p_CourseID);

    COMMIT;
    DBMS_OUTPUT.PUT_LINE('Student successfully enrolled in the course.');
EXCEPTION
    WHEN NO_DATA_FOUND THEN
        DBMS_OUTPUT.PUT_LINE('Student or Course not found.');
    WHEN OTHERS THEN
        
        ROLLBACK;
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
END EnrollStudent;
/

Not entirely sure why this error is popping up, any help would be greatly appreciated.

• sql
• oracle-database

Share Improve this question Follow edited Nov 20, 2024 at 22:43 MT0 169k1212 gold badges6666 silver badges127127 bronze badges asked Nov 20, 2024 at 20:25 Namikaze MinatoNamikaze Minato 311 bronze badge 1

• What you see, having transferred this code to a new command window, which's opened up right now , and compiling it ? – Barbaros Özhan Commented Nov 20, 2024 at 20:37

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

I copied your code into a sql developer worksheet, ran it and...

Procedure ENROLLSTUDENT compiled

LINE/COL  ERROR
--------- -------------------------------------------------------------
11/5      PL/SQL: SQL Statement ignored
12/10     PL/SQL: ORA-00942: table or view does not exist
15/5      PL/SQL: SQL Statement ignored
16/10     PL/SQL: ORA-00942: table or view does not exist
23/5      PL/SQL: SQL Statement ignored
24/10     PL/SQL: ORA-00942: table or view does not exist
31/5      PL/SQL: SQL Statement ignored
31/17     PL/SQL: ORA-00942: table or view does not exist
Errors: check compiler log

The procedure compiled. With errors, but it compiled. The errors are there because I don't have any of those tables.

Then I put the following code before the code I had pasted. Note that this is an incomplete anonymoust pl/sql code block. Why is it incomplete ? It's missing a trailing "/".

BEGIN
  NULL;
END;

and ran the whole thing again. The error now is ...

...
END EnrollStudent;
Error report -
ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "CREATE" 
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.
*Action:
...

So, most probably you have some other, incomplete, statement before the CREATE OR REPLACE

本文标签： sqlKeep getting error PLS00103 Encountered the symbol quotCREATEquotStack Overflow