You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!