Oracle 19.22存储过程禁用/启用FK约束报错求助

我有一个执行多项删除任务的存储过程PRC_GARBAGE，因新应用需求，需要先禁用一个外键（FK）约束。在过程中添加禁用和启用约束的EXECUTE IMMEDIATE语句后，运行时触发ORA-00933: SQL命令未正确结束错误，错误指向禁用约束的第19行，请问该语句存在什么问题？

存储过程完整代码如下：

CREATE OR REPLACE PROCEDURE <owner>."PRC_GARBAGE" (p_tage NUMBER, p_flag_tage NUMBER, p_flag_pin_tage NUMBER)
IS
   CURSOR c1
   IS
      SELECT *
        FROM tbl_gc
    ORDER BY sort_index;
   v_errm          VARCHAR2 (1000);
   v_para_cnt          NUMBER (9);
   v_ignore_stmnt    VARCHAR2 (1);
   v_job_status      NUMBER (2);
   v_cnt          NUMBER;
   v_zeit          TIMESTAMP := SYSTIMESTAMP - p_tage;
   v_flag_zeit       TIMESTAMP := SYSTIMESTAMP - p_flag_tage;
   v_flag_pin_zeit   TIMESTAMP := SYSTIMESTAMP - p_flag_pin_tage;
BEGIN
   execute immediate 'ALTER TABLE FALL disable constraint <owner>.<constraint_name> validate';
   SELECT status INTO v_job_status FROM jobstatus;
   FOR crec IN c1 LOOP
    v_ignore_stmnt := SUBSTR (crec.stmnt, 0, 1);
    --falls Job disabled und TBL-Abhaengigkeit besteht exec abklemmen
    IF crec.job_awareness = 1 AND v_job_status = 0 THEN
        v_ignore_stmnt := '#';
    END IF;
    IF (v_ignore_stmnt = '#') THEN
        INSERT INTO tbl_gc_log (tablename, executed, exectime)
         VALUES (crec.tablename, 'IGNORED >>' || v_errm || crec.stmnt, SYSTIMESTAMP);
    ELSE
        v_para_cnt := LENGTH (crec.stmnt) - LENGTH (REPLACE (crec.stmnt, ':', ''));
        BEGIN
        CASE v_para_cnt
            WHEN 2 THEN
            EXECUTE IMMEDIATE crec.stmnt USING v_flag_zeit, v_flag_pin_zeit;
            WHEN 1 THEN
            EXECUTE IMMEDIATE crec.stmnt USING v_zeit;
           WHEN 0 THEN
            EXECUTE IMMEDIATE crec.stmnt;
       END CASE;
        v_cnt := SQL%ROWCOUNT;
        INSERT INTO tbl_gc_log (tablename, executed, exectime)
             VALUES (crec.tablename, '(' || v_cnt || ' rows) ' || v_errm || crec.stmnt, SYSTIMESTAMP);
        EXCEPTION
        WHEN OTHERS THEN
            v_errm := SQLERRM;
            INSERT INTO tbl_gc_log (tablename, executed, exectime)
             VALUES (crec.tablename, v_errm || '>>' || crec.stmnt, SYSTIMESTAMP);
        END;
    END IF;
   END LOOP;
   execute immediate 'ALTER TABLE FALL enable constraint <owner>.<constraint_name> validate';
END prc_garbage;
/

触发ORA-00933的核心问题是禁用约束的SQL语句语法错误：

• 在Oracle中，DISABLE CONSTRAINT语句后不能跟VALIDATE关键字。VALIDATE仅用于启用约束（ENABLE CONSTRAINT）的场景，作用是验证表中现有数据是否符合约束规则；而禁用约束时不需要验证，添加该关键字会导致SQL语法不合法，触发命令未正确结束的错误。
• 额外注意：如果表FALL属于指定的<owner>用户，建议将表名写为<owner>.FALL，避免因当前用户权限或对象归属问题导致的其他异常。

将禁用和启用约束的语句修改为正确语法，去掉禁用语句中的validate，启用语句保留validate（若需验证现有数据）：

CREATE OR REPLACE PROCEDURE <owner>."PRC_GARBAGE" (p_tage NUMBER, p_flag_tage NUMBER, p_flag_pin_tage NUMBER)
IS
   CURSOR c1
   IS
      SELECT *
        FROM tbl_gc
    ORDER BY sort_index;
   v_errm          VARCHAR2 (1000);
   v_para_cnt          NUMBER (9);
   v_ignore_stmnt    VARCHAR2 (1);
   v_job_status      NUMBER (2);
   v_cnt          NUMBER;
   v_zeit          TIMESTAMP := SYSTIMESTAMP - p_tage;
   v_flag_zeit       TIMESTAMP := SYSTIMESTAMP - p_flag_tage;
   v_flag_pin_zeit   TIMESTAMP := SYSTIMESTAMP - p_flag_pin_tage;
BEGIN
   -- 修正：去掉DISABLE语句后的validate关键字，同时指定表的owner
   execute immediate 'ALTER TABLE <owner>.FALL disable constraint <owner>.<constraint_name>';
   SELECT status INTO v_job_status FROM jobstatus;
   FOR crec IN c1 LOOP
    v_ignore_stmnt := SUBSTR (crec.stmnt, 0, 1);
    --falls Job disabled und TBL-Abhaengigkeit besteht exec abklemmen
    IF crec.job_awareness = 1 AND v_job_status = 0 THEN
        v_ignore_stmnt := '#';
    END IF;
    IF (v_ignore_stmnt = '#') THEN
        INSERT INTO tbl_gc_log (tablename, executed, exectime)
         VALUES (crec.tablename, 'IGNORED >>' || v_errm || crec.stmnt, SYSTIMESTAMP);
    ELSE
        v_para_cnt := LENGTH (crec.stmnt) - LENGTH (REPLACE (crec.stmnt, ':', ''));
        BEGIN
        CASE v_para_cnt
            WHEN 2 THEN
            EXECUTE IMMEDIATE crec.stmnt USING v_flag_zeit, v_flag_pin_zeit;
            WHEN 1 THEN
            EXECUTE IMMEDIATE crec.stmnt USING v_zeit;
           WHEN 0 THEN
            EXECUTE IMMEDIATE crec.stmnt;
       END CASE;
        v_cnt := SQL%ROWCOUNT;
        INSERT INTO tbl_gc_log (tablename, executed, exectime)
             VALUES (crec.tablename, '(' || v_cnt || ' rows) ' || v_errm || crec.stmnt, SYSTIMESTAMP);
        EXCEPTION
        WHEN OTHERS THEN
            v_errm := SQLERRM;
            INSERT INTO tbl_gc_log (tablename, executed, exectime)
             VALUES (crec.tablename, v_errm || '>>' || crec.stmnt, SYSTIMESTAMP);
        END;
    END IF;
   END LOOP;
   -- 启用约束时保留validate（如果需要验证现有数据），同时指定表的owner
   execute immediate 'ALTER TABLE <owner>.FALL enable constraint <owner>.<constraint_name> validate';
END prc_garbage;
/

内容的提问来源于stack exchange，提问作者uwe A