Oracle Apex Error
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.

Ajax         plsql         oracle-apex        
Your Answer: 

1 Answers

This is Good Answer. Its helpfull for me.

Answered On 4th Oct,2017, 4:22am
Edit Account
LOGIN INFORMATION
Change Settings
Email Notifications Notifications will be sent to abcd@gmail.com
Select option for your email notifications:
Mature / News Filter We'll send on email when new jobs are posted
Option 2 for email notification We'll send on email when new jobs are posted