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.
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')
It is possible to insert sysdate directly into a column of type Date.