Oracle APEX PL/SQL错误

Question

我得到了这个PL/SQL语句：

BEGIN
    DELETE FROM REI_RETAIL_FACTOR_PARTS P
    WHERE  DEALER_NUMBER = :P13_FILTER_DEALER;

    INSERT INTO REI_RETAIL_FACTOR_PARTS
    (
        SELECT
            RF.TEILE_NR as "PART_NR",
            :P13_OVERWRITE_VALUE as "REQUESTED_RATE",
            sysdate as "REQUEST_DATE",
            :P13_FILTER_DEALER as "DEALER_NUMBER"
        FROM REI_RETAIL_FACTOR RF
        WHERE DEALER_NUMBER = :P13_FILTER_DEALER
    );
END;

错误是：

ORA-01861:文字不匹配格式字符串。

这真是令人沮丧，因为我从不尝试格式化任何东西。那么，为什么我要一直犯这个错误呢？

Answer 1

ORA-01861:文字不匹配格式字符串。

INSERT语法有错误。可能的解决办法：

( a)定义列列表：

BEGIN
    DELETE FROM REI_RETAIL_FACTOR_PARTS P
    WHERE  DEALER_NUMBER = :P13_FILTER_DEALER;

    INSERT INTO REI_RETAIL_FACTOR_PARTS(column_name1, ...)
        SELECT
            RF.TEILE_NR as "PART_NR",
            :P13_OVERWRITE_VALUE as "REQUESTED_RATE",
            sysdate as "REQUEST_DATE",
            :P13_FILTER_DEALER as "DEALER_NUMBER"
        FROM REI_RETAIL_FACTOR RF
        WHERE DEALER_NUMBER = :P13_FILTER_DEALER;
END;

( b)删除() (警告！( select中的列顺序至关重要)：

BEGIN
    DELETE FROM REI_RETAIL_FACTOR_PARTS P
    WHERE  DEALER_NUMBER = :P13_FILTER_DEALER;

    INSERT INTO REI_RETAIL_FACTOR_PARTS
        SELECT
            RF.TEILE_NR as "PART_NR",
            :P13_OVERWRITE_VALUE as "REQUESTED_RATE",
            sysdate as "REQUEST_DATE",
            :P13_FILTER_DEALER as "DEALER_NUMBER"
        FROM REI_RETAIL_FACTOR RF
        WHERE DEALER_NUMBER = :P13_FILTER_DEALER;
END;