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 FEBRUARY 24, 2013

Applies to:

Oracle Provider for OLE DB - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-Feb-2013***

Symptoms

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.

Changes

Upgraded to 11.2.0.1

Cause

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