[Oracle Target] When in Unlimited LOB mode, replication from SQL Database's NVARCHAR(MAX) type to Oracle's CLOB type fails with ORA-24806

HNAKAGAW — Fri, 12 Jun 2026 02:54:39 GMT

Hello support team

[Environment]

Source : Azure SQL Database

Target : Oracle 19c

[Situation]

- When in Unlimited LOB mode, replication from SQL Database's NVARCHAR(MAX) type to Oracle's CLOB type fails with ORA-24806.

- In both Full Load and Change Processing, when ORA-24806 occur , retries continue repeatedly.

- In Limited LOB mode, ORA-24806 does not occur in either FullLoad , Batch optimized apply , Transactional Apply.

- Changing the Oracle data type to NCLOB from CLOB prevents ORA-24806.

- Changing the Output Type of the column to CLOB in Table Settings > Transform does not prevent ORA-24806.

[Question]

Is there a workaround to prevent ORA-24806 from occurring while keeping Oracle data type CLOB?

Best Regards

Nakagawa

topic [Oracle Target] When in Unlimited LOB mode, replication from SQL Database's NVARCHAR(MAX) type to Oracle's CLOB type fails with ORA-24806 in Qlik Replicate