Data consistency

The ION Service delivers BODs to the database. The ION Service does not control the contents of the BOD or the actions performed inside the stored procedure.

Note: When defining stored statements or procedures you must be aware of the requirements or constraints of the database you are writing to. You can send data directly to a database. Business logic or validations, that are implemented in the application to which the database belongs, are bypassed in that case. Oracle database does not permit Read and Write operations simultaneously within the same procedure without relinquishing the transaction control. This can lead to the situation that the stored procedure execution may succeed but the full transaction from ION perspective may fail. Due to this incompatibility, currently the Request-Reply action and DB connector as an intermediate step are proven to work only with Microsoft SQL server.