Dear All,
We are using the 'Write to Data Store' smart process to write data into an Oracle DB v18c. The column 'ID' is a primary key and is auto-generated by the DB via a 'before insert' trigger that is calling a sequence. In the XSD file of the corresponding CDT we have the annotations @Id @GeneratedValue.
Writing data to the DB works fine. However, the ID value returned from the 'Write to Data Store' process is incorrect. Seems like a different sequence is used.
Any suggestions on how to solve this problem are highly appreciated. Thank you in advance!
Fabian
Discussion posts and replies are publicly visible