Inserting data into SQL Table from Oracle Integration

Summary:Inserting data into SQL Table from Oracle Integration

Content (required): When i do Insert data into SQL Table from Oracle Integration and where is some error on insert data(the data longer when the filed lenght) ,the responce in the REST doesn't show that where was some issue.So the flow doesn't enter to the failure scope and the integration doesn't know that the data was not inserted into the table in DB.How should i handle this kind of failure?

Tx

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):