My Oracle Support Banner

Executing a Query with an NVARCHAR2 in the Select List Using ORAOLEDB and Linked Server Fails With: Inconsistent Metadata (Doc ID 1268148.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Provider for OLE DB - Version and later
Information in this document applies to any platform.


Executing a query with an NVARCHAR2 in the select list using ORAOLEDB and linked aerver fails with:

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "OraOLEDB.Oracle" for linked server "SCOTTLINK" supplied inconsistent metadata for a column.
The column "COL1" (compile-time ordinal 1) of object ""SCOTT"."TESTNVARCHAR2"" was reported to have a "LENGTH" of 120 at compiletime and 240 at run time.


Upgraded to


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.