ORA-00903:数据类型不一致:应为-,但却获得CLOB 代码如下：
select road_name,ivs.start_stake,ivs.end_stake,ivs.segment_position,species_name,ist.tree_dbh,sum(amount) as amount,itv.tree_value,translate_type,translate_date,ist.unite,ivs.description from info_segment_tree ist
left join info_tree_species its on ist.st_species_id=its.species_id
left join info_tree_value itv on ist.st_species_id=itv.tv_species_id and ist.tree_dbh=itv.tree_dbh and ist.unite=itv.unite
left join info_virescence_segment ivs on ist.st_segment_id=ivs.segment_id
left join info_road_entity ire on ivs.info_road_entity_road_id=ire.road_id
where (select to_char(translate_date,'yyyy') from dual)='2014'
group by road_name,ivs.start_stake,ivs.end_stake,ivs.segment_position,species_name,ist.tree_dbh,itv.tree_value,translate_type,translate_date,ist.unite,ivs.description
各位大神，速速过来显灵，小弟在此感激不尽
------解决思路----------------------
先确定你的表结构中那些是clob，是不是有关联条件左右两边类型不一致导致的