How to pass SYSDATE parameter to OnPremise database using EPM Integration AGent select query
Hello,
I have a question regarding EPM Data Exchange EPM Agent integration with On Premise Database where we are trying to load incremental data from ERP On premise to ARCS.
Any one has idea regarding How to set the binding variable to receive SYSDATE value ?
WHen I am passing hard carded date as string values to pass in the binding variable it runs fine. But when I pass SYSDATE as a run time binding variable it fails with Error ORA-01858: a non-numeric character was found where a numeric was expected.
This will be of great help if any one has worked with this.
Tagged:
0