请问,做了一个Oracle SQL脚本,在PLSQL里能够正确执行,在5.5里确执行不了报错,请问是什么原因呢?错误代码:62400001LogLabel 29脚本如下select org_orgs.code,
org_orgs.name,
bd_accasoa.name,
bd_currtype.name,
tab.qmye
from (SELECT a.PK_ACCOUNTINGBOOK,
a.PK_ACCASOA,
a.PK_CURRTYPE,
((nvl(a.QCJF, 0) - nvl(a.QCDF, 0)) + nvl(b.FSJF, 0) -
nvl(b.FSDF, 0)) as qmye
FROM (SELECT DISTINCT gl_balan.pk_accountingbook,
gl_balan.pk_accasoa,
gl_balan.pk_currtype,
sum(gl_balan.debitamount) as qcjf,
sum(gl_balan.creditamount) as qcdf
FROM gl_balance gl_balan
WHERE gl_balan.year = '2021'
AND gl_balan.adjustperiod >= '00'
AND gl_balan.adjustperiod < '01'
AND gl_balan.voucherkind <> 5
AND gl_balan.pk_accasoa IN
(select pk_accasoa
from bd_accasoa
where dispname in ('1001\库存现金', '1002\银行存款'))
GROUP BY gl_balan.pk_accountingbook,
gl_balan.pk_accasoa,
gl_balan.pk_currtype) a
LEFT JOIN (SELECT gl_detail.pk_accountingbook,
gl_detail.pk_accasoa,
gl_detail.pk_currtype,
sum(gl_detail.debitamount) as fsjf,
sum(gl_detail.creditamount) as fsdf
FROM gl_detail gl_detail
WHERE gl_detail.pk_accasoa IN
(select pk_accasoa
from bd_accasoa
where dispname in
('1001\库存现金', '1002\银行存款'))
AND gl_detail.yearv = '2021'
AND gl_detail.adjustperiod >= '01'
AND gl_detail.adjustperiod <= '02'
AND gl_detail.dr = 0
AND gl_detail.discardflagv <> 'Y'
AND gl_detail.voucherkindv <> 255
AND gl_detail.tempsaveflag <> 'Y'
AND gl_detail.pk_managerv = 'N/A'
AND gl_detail.voucherkindv <> 5
GROUP BY gl_detail.pk_accountingbook,
gl_detail.pk_accasoa,
gl_detail.pk_currtype) b
ON a.PK_ACCOUNTINGBOOK = b.PK_ACCOUNTINGBOOK
AND a.PK_ACCASOA = b.PK_ACCASOA
AND a.PK_CURRTYPE = b.PK_CURRTYPE) tab
left join org_accountingbook
on tab.pk_accountingbook = org_accountingbook.pk_accountingbook
join bd_accasoa
on tab.pk_accasoa = bd_accasoa.pk_accasoa
join bd_currtype
on tab.pk_currtype = bd_currtype.pk_currtype
join org_orgs
on org_accountingbook.pk_relorg = org_orgs.pk_org