sql-server - MSSQL 链接服务器错误 : The OLE DB provider "OraOLEDB.Oracle" for linked server supplied inconsistent metadata for a column

Question

我试图将数据从 Oracle 拉到 MSSqlserver使用链接服务器的数据库。

select * from [LINK_NAME]..SCHEMA.TABLE;

但它因以下错误而失败:

The OLE DB provider "OraOLEDB.Oracle" for linked server "LINK_NAME" supplied inconsistent metadata for a column. The column "COLUMN_NAME" (compile-time ordinal 6) of object ""SCHEMA"."TABLE"" was reported to have a "LENGTH" of 100 at compile time and 200 at run time.

我还需要在运行时在 where 条件下传递参数。我发现 OPENQUERY 作为解决方案，但它在运行时不支持参数。

Answer 1

尝试使用 OPENQUERY 语法看看是否有帮助..

SELECT * FROM OPENQUERY(LINK_NAME, 'SELECT * FROM db.Schema.Table')

更多关于 OPENQUERY ...