Executing a Query with an NVARCHAR2 in the Select List Using ORAOLEDB and Linked Server Fails With: Inconsistent Metadata
Last updated on FEBRUARY 24, 2013
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms