link server查询oracle的view时出错请教

smile-wz

用SQL SERVER的link server查询oracle的view时出现编译时与运行时DBTYPE不同的错误。
请各位高手指点。谢谢。

查询语句及错误如下：

SELECT * FROM REALGL..REALGL.NS_VIEW_CLAIM_CASE

Server: 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.
OLE DB error trace [Non-interface error:  Column 'FEE_AMOUNT' (compile-time ordinal 10) of object '"REALGL"."NS_VIEW_CLAIM_CASE"' was reported to have a DBTYPE of 130 at compile time and 5 at run time].

NS_VIEW_CLAIM_CASE如下：
create or replace view ns_view_claim_case as
select distinct --tpl.internal_id as product_code,
  tcc.case_no,tcstm.real_name as insured_name,tcc.apply_name,tcc.accident_time,tcc.finish_time,tcs.status_id,tcs.status_name,
tac.audit_conclusion,tac.conclusion_desc,(select sum(tcf.fee_amount) from T_CLAIM_FEE tcf where tcf.case_id=tcc.case_id) as fee_amount
from T_CLAIM_CASE tcc,T_CLAIM_POLICY tcp,t_Claim_Product tclmp,T_CUSTOMER tcstm,
      T_PRODUCT_LIFE tpl,T_CASE_STATUS tcs,T_AUDIT_CONCLUSION tac
where tcc.case_id=tcp.case_id and tclmp.case_id=tcp.case_id and tclmp.policy_id=tcp.policy_id
  and tcc.insured_id=tcstm.customer_id and tpl.product_id=tclmp.product_id
  and tcc.case_status=tcs.status_id and tac.audit_conclusion=tclmp.audit_conclusion