oracle - PL/SQL：无法插入临时表

Question

我不太确定这个错误有什么问题。错误发生在下面的 INSERT INTO 语句中。我试图将上面游标循环中的值插入到临时表中。错误是“忽略 SQL 语句”

PROCEDURE loopHalfHourIntervals AS
sourceDay DATE;
sourceDayName VARCHAR2(10);
sourceInterval NUMBER(3);
sourceVolume FLOAT(20);
    CURSOR c_findValues IS
    SELECT DAY, hh, volume
    FROM V_NEM_RM16;
    BEGIN
    --FOR r_findValues IN c_findValues
        OPEN c_findValues;
        LOOP
        FETCH c_findValues INTO sourceDay, sourceInterval, sourceVolume;
            IF identifyHoliday(sourceDay) = TRUE
            THEN  sourceDayName := 'HOLIDAY';
            ELSE sourceDayName := trim(to_char(to_date(sourceDay, 'DD-MON-YYYY'),'day'));
            END IF;
       INSERT INTO tmpForecast --error occurred here
            (
                currentDay,
                dayInterval,
                volume
                            )
        VALUES
            (
                UPPPER(sourceDayName),
                sourceInterval,
                sourceVolume
                            ); 
        EXIT WHEN c_findValues%notfound;
        END LOOP;
        common.log('Holidays check completed and stored in tmp_forecast');
END loopHalfHourIntervals; ```

标签： oracleplsql