Oracle Apex错误

Question

begin
INSERT INTO REI_LABOUR_RATE
SELECT
    LR.BILLING_PARTNER AS DEALER_NUMBER,
    'GW' as BSI_GW,
    NULL as FLEET_DISCOUNT,
    NULL as RETAIL_RATE,
    LR.REQUESTED_RATE as REQUESTED_RATE,
    :P6_APPROVED_RATE as APPROVED_RATE,
    LR.REQUEST_DATE as REQUEST_DATE,
    :P6_APPROVAL_DATE as APPROVAL_DATE,
    to_char(sysdate,'DD.MON.YYYY') as RECORD_DATE,
    LR.NOTES as NOTES
FROM REI_LABOUR_RATE_REQUEST LR
WHERE BILLING_PARTNER = :P6_FILTER_DEALER;

DELETE FROM REI_LABOUR_RATE_REQUEST
WHERE BILLING_PARTNER = :P6_FILTER_DEALER;

end;

使用此SQL代码执行动态操作后，将得到以下错误：

Ajax调用返回服务器错误ORA-01858:在执行PL/SQL代码时发现一个非数字字符。

我到底在哪里搞砸的？我敢打赌这一定是和糖浆有关的。

Answer 1

可以将sysdate直接插入到Date类型的列中。

Answer 2

插入数据库时，必须转换带有类型日期选择器的顶级项。

如果顶点项:P6_APPROVAL_DATE是日期选择字段，则必须转换如下值：TO_DATE(:P6_APPROVAL_DATE，'DD.MON.YYYY')