Hello,
we had created a scenario file to jdbc. while sending file to Oracle DB, it shows error as "ORA-01861: literal does not match format string". we checked the literals and white spaces. still we have same problem. so i have doubt on DATE format. we are sending date from PI system as yyyyMMdd which is not supported by Oracle i think. So please provide the DATE format accepted by Oracle and how to pass from SAP PI mapping. it will be appreciable if provide Steps to do in mapping or UDF code sample.
Also in response status we get the error "ORA-00917: missing comma ". So plz let me know how to solve this issue.
Thanks in Advance.