This content has been marked as final. Show 2 replies
As insert on DB is a one way operation. You can check when you created the DB adapter , with pure SQL statement the XSD was not having any return element created in it.
In OSB you will need to use publish action for pushing data into the DB as service callout will not work.
One more thing you can do, use route node to insert data through BS , this will ultimately make sure that error is returned back (when insert fails) .
- It is considered good etiquette to reward answerers with points (as "helpful" - 5 pts - or "correct" - 10pts).
You can use publish action for pushing data into the DB and setting the routing option for the publish node to exactly once and use a fault handler. If you do not get a fault then you be pretty assured that the record has been inserted. If you really want the count you can keep the count of records before and after the insert operation is called.