WMS_ERP 是我建立的一个远程服务器（Oracle的）SQL里的查询语句：
SELECT * FROM WMS_ERP..APPS.EINV_WMS_DELIVER_INTF_VIEW
报错：OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'ORGANIZATION_ID' (compile-time ordinal 8) of object '"APPS"."EINV_WMS_DELIVER_INTF_VIEW"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].上面一句sql换成另一个方式查询：
SELECT *
FROM OPENQUERY(WMS_ERP,'SELECT * FROM APPS.EINV_WMS_DELIVER_INTF_VIEW ')这样就可以查询！！！为什么啊，求解是不是因为那个视图里有个字段是number类型的，而sql没有number类型的原因啊
跪求真相！
SELECT * FROM WMS_ERP..APPS.EINV_WMS_DELIVER_INTF_VIEW
报错：OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.
OLE DB error trace [Non-interface error: Column 'ORGANIZATION_ID' (compile-time ordinal 8) of object '"APPS"."EINV_WMS_DELIVER_INTF_VIEW"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].上面一句sql换成另一个方式查询：
SELECT *
FROM OPENQUERY(WMS_ERP,'SELECT * FROM APPS.EINV_WMS_DELIVER_INTF_VIEW ')这样就可以查询！！！为什么啊，求解是不是因为那个视图里有个字段是number类型的，而sql没有number类型的原因啊
跪求真相！
希望能帮到你