Query field with NVARCHAR(MAX) at SQL Server returns ORA-00932

@INFO_SQLDB

Hi,

I need to run the following query:

CREATE MATERIALIZED VIEW mv_test TABLESPACE BUSINESS_TBSPACE

AS (SELECT TO_LOB("PDATABASE"."EntityNumber") "EntityNumber"

FROM "dbo"."ent_details"@INFO_SQLDB "PDATABASE");

Getting this error:

ORA-00932: inconsistent datatypes: expected LONG BINARY got NCHAR

00932. 00000 - "inconsistent datatypes: expected %s got %s"

DBLink established using Database Gateway for SQL Server 19c. My Oracle Database is 19c. The column EntityNumber has short values like 'P012345678'. TO_LOB() doesn't work. Database characterset is Unicode AL32UTF8.

I'm out of ideas. Can anyone help?

Thanks in advance.

Jenn.