cannot Select data Oracle from SQL

[Levina]

Dear All,
we got some problem where we try to select / delete data Oracle Table from SQL.

Datatype column 'ID' in Oracle table is number.

OLE DB error trace [Non-interface error: Column 'ID' (compile-time ordinal 1) of object '"oracle_user"."oracle_table"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].
Msg 7356, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

we use Linkedserver with provider MSDAORA and Oracle 9.1 version and SQL 2000

please help help ..
Thank you for your solution

[skhanal]

Check the date value in the column, it may be invalid for SQL Server. Oracle and SQL have different valid date range.