Oracle Create/Update scripts

Camunda 7 Topics Discussion & Questions
1

Hi,

in the script oracle_engine_7.9_to_7.10.sql there seems to be an error in the statement

ALTER TABLE ACT_GE_BYTEARRAY
  ADD ROOT_PROC_INST_ID_ varchar(64);

I think, the datatype should be
NVARCHAR2(64)

The create script oracle_engine_7.12.0 has the same datatype for this column.

create table ACT_GE_BYTEARRAY (
    ID_ NVARCHAR2(64),
    REV_ INTEGER,
    NAME_ NVARCHAR2(255),
    DEPLOYMENT_ID_ NVARCHAR2(64),
    BYTES_ BLOB,
    GENERATED_ NUMBER(1,0) CHECK (GENERATED_ IN (1,0)),
    TENANT_ID_ NVARCHAR2(64),
    TYPE_ INTEGER,
    CREATE_TIME_ TIMESTAMP(6),
    ROOT_PROC_INST_ID_ varchar(64),
    REMOVAL_TIME_ TIMESTAMP(6),
    primary key (ID_)
);

All other tables referencing the ROOT_PROC_INST_ID are using the NVARCHAR2 type

I got the scripts from camunda-bpm-tomcat-7.12.0.zip

2

@Michael_Rosenauer you can change varchar(64) to NVARCHAR2(64)

Related issue discussed in this post:

3