We are doing a trigger-based synch with DB Convert studio tool from Oracle as a source. This method creates triggers on each table and a history_store table.
But, the software that uses the source oracle DB gives the following error and refuses to work:
Unknown type (table: history_store, column: pk_date_dest, type: 0)
The pk_date_dest column is initialized as "pk_date_dest" NVARCHAR2(400) NOT NULL. What might be the reason for this type 0?
I changed manually the NVARCHAR2 data type of the columns to VARCHAR2 and the error stopped appearing. Quite strange to be honest, as there are NVARCHAR2 data types in other tables that are native to the database, but... at least that fixed it.
ALTER TABLE tablename MODIFY ("pk_date_dest" VARCHAR2(400));