SQL link Oracle data indefinite length problem

select * from test..TEST.TEST1

Server: Message 7356, Level 16, State 1, line 1

OLE DB provider ' oraoledb.oracle ' provides inconsistent metadata for the column. Meta data information was changed while executing.

OLE DB Error Tracking

［Non-interface error:　
Column 'DUMMY' (compile-time ordinal 1) of object '"TEST".
"TEST"' was reported to have a DBTYPE of 129 at
compile time and 130 at run time］。

Here we find that when using a precision data type, the query does not report errors of this metadata type mismatch.

This is Oracle's bug:3117040 in 9.2.0.4.10.

So if the Oracle version is lower than this, avoid using data types with no precision (indefinite data length) in the column that SQL Server's link seerver needs to access.