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;

After executing a Dynamic Action with this SQL code I get this error:

Ajax call returned server error ORA-01858: a non-numeric character was found where a numeric was expected for Execute PL/SQL Code.

Where did I screw up exactly? I bet it has something to do with the sysdate.

Answer 1

The apex items with type Date Picker must be converted when inserted into the database.

If the apex item :P6_APPROVAL_DATE is a Date Picker field, then you must convert the value like: TO_DATE(:P6_APPROVAL_DATE, 'DD.MON.YYYY')