Can a UnitySync connection to Oracle insert the next sequential value for an ID?Created: 2012-04-20 08:09:59
Modified: 2017-06-04 18:26:53
Tags: Oracle UnitySync
Unfortunately, no. UnitySync can not assign the next number in a sequence of an Oracle database column.
Oracle can be configured to do it automatically, however. Then the UnitySync connection would simply not set that column value. When the new Oracle record is created by UnitySync without the key field populated, the record would automatically be assigned the next sequential value.
Have your DB Admin review the functionality of Auto Incrementing Columns in Oracle. Helpful links: