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

Writeback to Oracle DB integration agent does not give error if the SQL insert is incomplete

in EPM Platform and Freeform 2 comments

Hi,

I have a scenario in Oracle ARCS where i am doing writeback to Onpremise Oracle database using SQL in EPM integration agent.
I am loading the csv file using insert query in Oracle.
We had one row which had a value with wild card character ($) in data type column varchar 2.
The insert statement stop and only inserted the rows til it found above row. But the integration did not fail. We had no failure message regarding this.
Only when counting the number of rows in Oracle, We came to know that the insert was incomplete.
Is there anything i am missing here to get a failure message if the insert stops.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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