To upgrade Camunda database from 7.8 to 7.11 we use the database scripts in the Camunda Nexus (https://app.camunda.com/nexus/repository/public/org/camunda/bpm/distro/camunda-sql-scripts/7.11.0/camunda-sql-scripts-7.11.0.zip)
We noticed that there are some inconsistencies between the create script and the upgrade script for Oracle.
In oracle_engine_7.9_to_7.10.sql, ROOT_PROC_INST_ID_ is added to several tables with type NVARCHAR2(64).
ALTER TABLE ACT_HI_DEC_IN
ADD ROOT_PROC_INST_ID_ NVARCHAR2(64);
ALTER TABLE ACT_HI_DEC_OUT
ADD ROOT_PROC_INST_ID_ NVARCHAR2(64);
While in the create script oracle_engine_7.11.0.sql
create table ACT_HI_DEC_IN (
...
ROOT_PROC_INST_ID_ varchar(64),
...
);
create table ACT_HI_DEC_OUT (
...
ROOT_PROC_INST_ID_ varchar(64),
...
);
We decided on using NVARCHAR2(64) but can anyone confirm this is the way to go?