急!关于用full join产生sql语句报错的问题,请高手赐教!!!
我在VB下通过ADO访问ORACLE 9i数据库,以下是我的sql语句
sql=“select z.facctclass as lb,sum(z.fendbal) as fje from (select NVL(x.fkmh,y.facctcode) as kmdm,NVL(x.facctclass,y.facctclass) as facctclass,NVL(y.fendbal,0)+ NVL(x.fjje,0) -NVL(x.fdje,0) as fendbal from (select a.fkmh,b.facctclass,cast(sum(case when a.fjd='J' then a.fbal else 0 end) as dec(18,2)) as fjje,cast(sum(case when a.fjd='D' then a.fbal else 0 end) as dec(18,2)) as fdje from A2003001FCwvch a, A2003001LAccount b where a.fkmh=b.facctcode and b.facctclass in ('制造类','外购类') and a.fterm=1 and to_number(to_char(a.fdate,'yyyy'))=2003 and a.fdate<to_date('2003-01-18','yyyy-mm-dd') group by a.fkmh,b.facctclass) X full join (select c.facctcode,c.fendbal,d.facctclass from A2003001LBalance c join A2003001LAccount d on c.facctcode=d.facctcode where c.fmonth=0 and d.facctdetail=1 and d.facctclass in ('制造类','外购类')) Y on x.fkmh=y.facctcode ) Z group by z.facctclass”
此条语句在我的机器上运行无误,可是我放到客户的服务器上运行时报错,错误为
ORA-00600: 内部错误代码,参数: [qcscpqbc1], [2], [0], [], [], [], [], []
注:我机器上的oracle安装在windows 2000下,而客户的服务器时UNIX的
请问这是什么原因呀???