问题不在那里,还在SQL中,先看见这些问题,试一下: where to_char(t.taxpayerinputdate,''yyyy-mm-dd'')='''|| V_CurrentDate||'''
---- ---
and t.taxregcode=t3.taxregcode
and substr(t3.mngregioncode,1,2) in ('''||V_MngCode||''')
---- ---
and t.levydeclareformtypecode=t2.levydeclareformtypecode group by t2.levydeclareformtypename) a,
(select t2.levydeclareformtypename type1,Count(distinct t.taxregcode) count1,
sum(t.levyAccount) mount1 from tb_web_declareinfo t,tb_web_levydeclareformtype t2,tb_web_taxpayerbasicinfo t3
where to_char(t.taxpayerinputdate,''yyyy-mm-dd'')<='''|| V_CurrentDate||'''
--- ---
and to_char(t.taxpayerinputdate,''yyyy-mm-dd'')>= '''|| V_MonthBegin||'''
and t.taxregcode=t3.taxregcode
and substr(t3.mngregioncode,1,2) in ('''||V_MngCode||''')
and t.levydeclareformtypecode=t2.levydeclareformtypecode group by t2.levydeclareformtypename) b
where a.type1(+)=b.type1 ';
---- ---
and t.taxregcode=t3.taxregcode
and substr(t3.mngregioncode,1,2) in ('''||V_MngCode||''')
---- ---
and t.levydeclareformtypecode=t2.levydeclareformtypecode group by t2.levydeclareformtypename) a,
(select t2.levydeclareformtypename type1,Count(distinct t.taxregcode) count1,
sum(t.levyAccount) mount1 from tb_web_declareinfo t,tb_web_levydeclareformtype t2,tb_web_taxpayerbasicinfo t3
where to_char(t.taxpayerinputdate,''yyyy-mm-dd'')<='''|| V_CurrentDate||'''
--- ---
and to_char(t.taxpayerinputdate,''yyyy-mm-dd'')>= '''|| V_MonthBegin||'''
and t.taxregcode=t3.taxregcode
and substr(t3.mngregioncode,1,2) in ('''||V_MngCode||''')
and t.levydeclareformtypecode=t2.levydeclareformtypecode group by t2.levydeclareformtypename) b
where a.type1(+)=b.type1 ';
V_mngcode 别加了