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 APRIL 09, 2020
Applies to:Oracle Provider for OLE DB - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Feb-2013***
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 184.108.40.206
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