1       16:51:18  SQL Prepare: ORACLE - BEGIN "SP_SF_MZKSSR_XMSR00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_FBMC00 => :AS_FBMC00,AS_TJLB00 => :AS_TJLB00,AS_KSMC00 => :AS_KSMC00,AS_YYID00 => :AS_YYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
2       16:51:18  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090902
3       16:51:18  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
4       16:51:18  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20090902
5       16:51:18  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
6       16:51:18  SQL Data In: ORACLE - Param = 5, Name = AS_FBMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有病人
7       16:51:18  SQL Data In: ORACLE - Param = 6, Name = AS_TJLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
8       16:51:18  SQL Data In: ORACLE - Param = 7, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 所有科室
9       16:51:18  SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
10      16:51:18  SQL Data In: ORACLE - Param = 9, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
11      16:51:18  SQL Data In: ORACLE - Param = 10, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
12      16:51:18  SQL Data In: ORACLE - Param = 11, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
13      16:51:18  SQL Execute: ORACLE - BEGIN "SP_SF_MZKSSR_XMSR00" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_FBMC00 => :AS_FBMC00,AS_TJLB00 => :AS_TJLB00,AS_KSMC00 => :AS_KSMC00,AS_YYID00 => :AS_YYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
14      16:51:19  SQL Prepare: ORACLE - select C.XMMC00,sum(B.SFJE00) SFJE00,sum(A.XMHJ00) XMHJ00,sum(A.SFXM01) SFXM01,sum(A.SFXM02) SFXM02,sum(A.SFXM03) SFXM03,sum(A.SFXM04) SFXM04,sum(A.SFXM05) SFXM05,sum(A.SFXM06) SFXM06, 
sum(A.SFXM07) SFXM07,sum(A.SFXM08) SFXM08,sum(A.SFXM09) SFXM09,sum(A.SFXM10) SFXM10,sum(A.SFXM11) SFXM11,sum(A.SFXM12) SFXM12,sum(A.SFXM13) SFXM13,sum(A.SFXM14) SFXM14,sum(A.SFXM15) SFXM15,sum(A.SFXM16) SFXM16,
sum(A.SFXM17) SFXM17,sum(A.SFXM18) SFXM18,sum(A.SFXM19) SFXM19,sum(A.SFXM20) SFXM20,
sum(A.SFXM21) SFXM21,sum(A.SFXM22) SFXM22,sum(A.SFXM23) SFXM23,sum(A.SFXM24) SFXM24,sum(A.SFXM25) SFXM25,sum(A.SFXM26) SFXM26,sum(A.SFXM27) SFXM27,sum(A.SFXM28) SFXM28,
sum(SFXM29) SFXM29,sum(SFXM30) SFXM30,sum(SFXM31) SFXM31,sum(SFXM32) SFXM32,sum(SFXM33) SFXM33,sum(SFXM34) SFXM34,sum(SFXM35) SFXM35,sum(SFXM36) SFXM36,sum(SFXM37) SFXM37,
sum(SFXM38) SFXM38,sum(SFXM39) SFXM39,sum(SFXM40) SFXM40,sum(SFXM41) SFXM41,sum(SFXM42) SFXM42,sum(SFXM43) SFXM43,
sum(SFXM44) SFXM44,sum(SFXM45) SFXM45,sum(SFXM46) SFXM46,sum(SFXM47) SFXM47,sum(SFXM48) SFXM48,sum(SFXM49) SFXM49,sum(SFXM50) SFXM50,sum(SFXM51) SFXM51,sum(SFXM52) SFXM52,
sum(SFXM53) SFXM53,sum(SFXM54) SFXM54,sum(SFXM55) SFXM55,sum(SFXM56) SFXM56,sum(SFXM57) SFXM57,sum(SFXM58) SFXM58,
sum(SFXM59) SFXM59,sum(SFXM60) SFXM60,sum(SFXM61) SFXM61,sum(SFXM62) SFXM62,sum(SFXM63) SFXM63,sum(SFXM64) SFXM64,sum(SFXM65) SFXM65,sum(SFXM66) SFXM66,sum(SFXM67) SFXM67,
sum(SFXM68) SFXM68,sum(SFXM69) SFXM69,sum(SFXM70) SFXM70,sum(SFXM71) SFXM71,sum(SFXM72) SFXM72,sum(SFXM73) SFXM73,
sum(SFXM74) SFXM74,sum(SFXM75) SFXM75,sum(SFXM76) SFXM76,sum(SFXM77) SFXM77,sum(SFXM78) SFXM78,sum(SFXM79) SFXM79,sum(SFXM80) SFXM80, 
sum(SFXM81)  SFXM81, sum(SFXM82)  SFXM82, sum(SFXM83)  SFXM83, sum(SFXM84)  SFXM84, sum(SFXM85)  SFXM85, sum(SFXM86)  SFXM86, sum(SFXM87)  SFXM87, sum(SFXM88)  SFXM88, sum(SFXM89)  SFXM89, sum(SFXM90)  SFXM90, 
sum(SFXM91)  SFXM91, sum(SFXM92)  SFXM92, sum(SFXM93)  SFXM93, sum(SFXM94)  SFXM94, sum(SFXM95)  SFXM95, sum(SFXM96)  SFXM96, sum(SFXM97)  SFXM97, sum(SFXM98)  SFXM98, sum(SFXM99)  SFXM99, sum(SFXM100) SFXM100, 
sum(SFXM101) SFXM101,sum(SFXM102) SFXM102,sum(SFXM103) SFXM103,sum(SFXM104) SFXM104,sum(SFXM105) SFXM105,sum(SFXM106) SFXM106,sum(SFXM107) SFXM107,sum(SFXM108) SFXM108,sum(SFXM109) SFXM109,sum(SFXM110) SFXM110, 
sum(SFXM111) SFXM111,sum(SFXM112) SFXM112,sum(SFXM113) SFXM113,sum(SFXM114) SFXM114,sum(SFXM115) SFXM115,sum(SFXM116) SFXM116,sum(SFXM117) SFXM117,sum(SFXM118) SFXM118,sum(SFXM119) SFXM119,sum(SFXM120) SFXM120, 
sum(SFXM121) SFXM121,sum(SFXM122) SFXM122,sum(SFXM123) SFXM123,sum(SFXM124) SFXM124,sum(SFXM125) SFXM125,sum(SFXM126) SFXM126,sum(SFXM127) SFXM127,sum(SFXM128) SFXM128,sum(SFXM129) SFXM129,sum(SFXM130) SFXM130, 
sum(SFXM131) SFXM131,sum(SFXM132) SFXM132,sum(SFXM133) SFXM133,sum(SFXM134) SFXM134,sum(SFXM135) SFXM135,sum(SFXM136) SFXM136,sum(SFXM137) SFXM137,sum(SFXM138) SFXM138,sum(SFXM139) SFXM139,sum(SFXM140) SFXM140, 
sum(SFXM141) SFXM141,sum(SFXM142) SFXM142,sum(SFXM143) SFXM143,sum(SFXM144) SFXM144,sum(SFXM145) SFXM145,sum(SFXM146) SFXM146,sum(SFXM147) SFXM147,sum(SFXM148) SFXM148,sum(SFXM149) SFXM149,sum(SFXM150) SFXM150, 
sum(SFXM151) SFXM151,sum(SFXM152) SFXM152,sum(SFXM153) SFXM153,sum(SFXM154) SFXM154,sum(SFXM155) SFXM155,sum(SFXM156) SFXM156,sum(SFXM157) SFXM157,sum(SFXM158) SFXM158,sum(SFXM159) SFXM159,sum(SFXM160) SFXM160, 
sum(SFXM161) SFXM161,sum(SFXM162) SFXM162,sum(SFXM163) SFXM163,sum(SFXM164) SFXM164,sum(SFXM165) SFXM165,sum(SFXM166) SFXM166,sum(SFXM167) SFXM167,sum(SFXM168) SFXM168,sum(SFXM169) SFXM169,sum(SFXM170) SFXM170, 
sum(SFXM171) SFXM171,sum(SFXM172) SFXM172,sum(SFXM173) SFXM173,sum(SFXM174) SFXM174,sum(SFXM175) SFXM175,sum(SFXM176) SFXM176,sum(SFXM177) SFXM177,sum(SFXM178) SFXM178,sum(SFXM179) SFXM179,sum(SFXM180) SFXM180, 
sum(SFXM181) SFXM181,sum(SFXM182) SFXM182,sum(SFXM183) SFXM183,sum(SFXM184) SFXM184,sum(SFXM185) SFXM185,sum(SFXM186) SFXM186,sum(SFXM187) SFXM187,sum(SFXM188) SFXM188,sum(SFXM189) SFXM189,sum(SFXM190) SFXM190, 
sum(SFXM191) SFXM191,sum(SFXM192) SFXM192,sum(SFXM193) SFXM193,sum(SFXM194) SFXM194,sum(SFXM195) SFXM195,sum(SFXM196) SFXM196,sum(SFXM197) SFXM197,sum(SFXM198) SFXM198,sum(SFXM199) SFXM199,sum(SFXM200) SFXM200, 
sum(SFXM201) SFXM201,sum(SFXM202) SFXM202,sum(SFXM203) SFXM203,sum(SFXM204) SFXM204,sum(SFXM205) SFXM205,sum(SFXM206) SFXM206,sum(SFXM207) SFXM207,sum(SFXM208) SFXM208,sum(SFXM209) SFXM209,sum(SFXM210) SFXM210, 
sum(SFXM211) SFXM211,sum(SFXM212) SFXM212,sum(SFXM213) SFXM213,sum(SFXM214) SFXM214,sum(SFXM215) SFXM215,sum(SFXM216) SFXM216,sum(SFXM217) SFXM217,sum(SFXM218) SFXM218,sum(SFXM219) SFXM219,sum(SFXM220) SFXM220, 
sum(SFXM221) SFXM221,sum(SFXM222) SFXM222,sum(SFXM223) SFXM223,sum(SFXM224) SFXM224,sum(SFXM225) SFXM225,sum(SFXM226) SFXM226,sum(SFXM227) SFXM227,sum(SFXM228) SFXM228,sum(SFXM229) SFXM229,sum(SFXM230) SFXM230, 
sum(SFXM231) SFXM231,sum(SFXM232) SFXM232,sum(SFXM233) SFXM233,sum(SFXM234) SFXM234,sum(SFXM235) SFXM235,sum(SFXM236) SFXM236,sum(SFXM237) SFXM237,sum(SFXM238) SFXM238,sum(SFXM239) SFXM239,sum(SFXM240) SFXM240, 
sum(SFXM241) SFXM241,sum(SFXM242) SFXM242,sum(SFXM243) SFXM243,sum(SFXM244) SFXM244,sum(SFXM245) SFXM245,sum(SFXM246) SFXM246,sum(SFXM247) SFXM247,sum(SFXM248) SFXM248,sum(SFXM249) SFXM249,sum(SFXM250) SFXM250 
 from  BM_YYSFTJ A,BM_YYSFXM B,BM_FPXM00 C  where  A.BMBH00 = B.SFXMID and B.MZFPID=C.FPXMID  and A.ID0000 =:1 group by C.XMMC00 
union all 
select ' 总 计' XMMC00,B.SFJE00,A.XMHJ00,A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06, 
A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16,
A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20,
A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31,
A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42,
A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53,
A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64,
A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75,
A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80,
SFXM81, SFXM82, SFXM83, SFXM84, SFXM85, SFXM86, SFXM87, SFXM88, SFXM89, SFXM90, 
SFXM91, SFXM92, SFXM93, SFXM94, SFXM95, SFXM96, SFXM97, SFXM98, SFXM99, SFXM100, 
SFXM101,SFXM102,SFXM103,SFXM104,SFXM105,SFXM106,SFXM107,SFXM108,SFXM109,SFXM110, 
SFXM111,SFXM112,SFXM113,SFXM114,SFXM115,SFXM116,SFXM117,SFXM118,SFXM119,SFXM120, 
SFXM121,SFXM122,SFXM123,SFXM124,SFXM125,SFXM126,SFXM127,SFXM128,SFXM129,SFXM130, 
SFXM131,SFXM132,SFXM133,SFXM134,SFXM135,SFXM136,SFXM137,SFXM138,SFXM139,SFXM140, 
SFXM141,SFXM142,SFXM143,SFXM144,SFXM145,SFXM146,SFXM147,SFXM148,SFXM149,SFXM150, 
SFXM151,SFXM152,SFXM153,SFXM154,SFXM155,SFXM156,SFXM157,SFXM158,SFXM159,SFXM160, 
SFXM161,SFXM162,SFXM163,SFXM164,SFXM165,SFXM166,SFXM167,SFXM168,SFXM169,SFXM170, 
SFXM171,SFXM172,SFXM173,SFXM174,SFXM175,SFXM176,SFXM177,SFXM178,SFXM179,SFXM180, 
SFXM181,SFXM182,SFXM183,SFXM184,SFXM185,SFXM186,SFXM187,SFXM188,SFXM189,SFXM190, 
SFXM191,SFXM192,SFXM193,SFXM194,SFXM195,SFXM196,SFXM197,SFXM198,SFXM199,SFXM200, 
SFXM201,SFXM202,SFXM203,SFXM204,SFXM205,SFXM206,SFXM207,SFXM208,SFXM209,SFXM210, 
SFXM211,SFXM212,SFXM213,SFXM214,SFXM215,SFXM216,SFXM217,SFXM218,SFXM219,SFXM220, 
SFXM221,SFXM222,SFXM223,SFXM224,SFXM225,SFXM226,SFXM227,SFXM228,SFXM229,SFXM230, 
SFXM231,SFXM232,SFXM233,SFXM234,SFXM235,SFXM236,SFXM237,SFXM238,SFXM239,SFXM240, 
SFXM241,SFXM242,SFXM243,SFXM244,SFXM245,SFXM246,SFXM247,SFXM248,SFXM249,SFXM250 
 from  BM_YYSFTJ A,BM_YYSFXM B  where  A.BMBH00 = B.SFXMID(+) and A.BMBH00=999999999 and A.ID0000 =:2 

15      16:51:19  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 595918.000000
16      16:51:19  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 595918.000000
17      16:51:19  SQL Execute: ORACLE - select C.XMMC00,sum(B.SFJE00) SFJE00,sum(A.XMHJ00) XMHJ00,sum(A.SFXM01) SFXM01,sum(A.SFXM02) SFXM02,sum(A.SFXM03) SFXM03,sum(A.SFXM04) SFXM04,sum(A.SFXM05) SFXM05,sum(A.SFXM06) SFXM06, 
sum(A.SFXM07) SFXM07,sum(A.SFXM08) SFXM08,sum(A.SFXM09) SFXM09,sum(A.SFXM10) SFXM10,sum(A.SFXM11) SFXM11,sum(A.SFXM12) SFXM12,sum(A.SFXM13) SFXM13,sum(A.SFXM14) SFXM14,sum(A.SFXM15) SFXM15,sum(A.SFXM16) SFXM16,
sum(A.SFXM17) SFXM17,sum(A.SFXM18) SFXM18,sum(A.SFXM19) SFXM19,sum(A.SFXM20) SFXM20,
sum(A.SFXM21) SFXM21,sum(A.SFXM22) SFXM22,sum(A.SFXM23) SFXM23,sum(A.SFXM24) SFXM24,sum(A.SFXM25) SFXM25,sum(A.SFXM26) SFXM26,sum(A.SFXM27) SFXM27,sum(A.SFXM28) SFXM28,
sum(SFXM29) SFXM29,sum(SFXM30) SFXM30,sum(SFXM31) SFXM31,sum(SFXM32) SFXM32,sum(SFXM33) SFXM33,sum(SFXM34) SFXM34,sum(SFXM35) SFXM35,sum(SFXM36) SFXM36,sum(SFXM37) SFXM37,
sum(SFXM38) SFXM38,sum(SFXM39) SFXM39,sum(SFXM40) SFXM40,sum(SFXM41) SFXM41,sum(SFXM42) SFXM42,sum(SFXM43) SFXM43,
sum(SFXM44) SFXM44,sum(SFXM45) SFXM45,sum(SFXM46) SFXM46,sum(SFXM47) SFXM47,sum(SFXM48) SFXM48,sum(SFXM49) SFXM49,sum(SFXM50) SFXM50,sum(SFXM51) SFXM51,sum(SFXM52) SFXM52,
sum(SFXM53) SFXM53,sum(SFXM54) SFXM54,sum(SFXM55) SFXM55,sum(SFXM56) SFXM56,sum(SFXM57) SFXM57,sum(SFXM58) SFXM58,
sum(SFXM59) SFXM59,sum(SFXM60) SFXM60,sum(SFXM61) SFXM61,sum(SFXM62) SFXM62,sum(SFXM63) SFXM63,sum(SFXM64) SFXM64,sum(SFXM65) SFXM65,sum(SFXM66) SFXM66,sum(SFXM67) SFXM67,
sum(SFXM68) SFXM68,sum(SFXM69) SFXM69,sum(SFXM70) SFXM70,sum(SFXM71) SFXM71,sum(SFXM72) SFXM72,sum(SFXM73) SFXM73,
sum(SFXM74) SFXM74,sum(SFXM75) SFXM75,sum(SFXM76) SFXM76,sum(SFXM77) SFXM77,sum(SFXM78) SFXM78,sum(SFXM79) SFXM79,sum(SFXM80) SFXM80, 
sum(SFXM81)  SFXM81, sum(SFXM82)  SFXM82, sum(SFXM83)  SFXM83, sum(SFXM84)  SFXM84, sum(SFXM85)  SFXM85, sum(SFXM86)  SFXM86, sum(SFXM87)  SFXM87, sum(SFXM88)  SFXM88, sum(SFXM89)  SFXM89, sum(SFXM90)  SFXM90, 
sum(SFXM91)  SFXM91, sum(SFXM92)  SFXM92, sum(SFXM93)  SFXM93, sum(SFXM94)  SFXM94, sum(SFXM95)  SFXM95, sum(SFXM96)  SFXM96, sum(SFXM97)  SFXM97, sum(SFXM98)  SFXM98, sum(SFXM99)  SFXM99, sum(SFXM100) SFXM100, 
sum(SFXM101) SFXM101,sum(SFXM102) SFXM102,sum(SFXM103) SFXM103,sum(SFXM104) SFXM104,sum(SFXM105) SFXM105,sum(SFXM106) SFXM106,sum(SFXM107) SFXM107,sum(SFXM108) SFXM108,sum(SFXM109) SFXM109,sum(SFXM110) SFXM110, 
sum(SFXM111) SFXM111,sum(SFXM112) SFXM112,sum(SFXM113) SFXM113,sum(SFXM114) SFXM114,sum(SFXM115) SFXM115,sum(SFXM116) SFXM116,sum(SFXM117) SFXM117,sum(SFXM118) SFXM118,sum(SFXM119) SFXM119,sum(SFXM120) SFXM120, 
sum(SFXM121) SFXM121,sum(SFXM122) SFXM122,sum(SFXM123) SFXM123,sum(SFXM124) SFXM124,sum(SFXM125) SFXM125,sum(SFXM126) SFXM126,sum(SFXM127) SFXM127,sum(SFXM128) SFXM128,sum(SFXM129) SFXM129,sum(SFXM130) SFXM130, 
sum(SFXM131) SFXM131,sum(SFXM132) SFXM132,sum(SFXM133) SFXM133,sum(SFXM134) SFXM134,sum(SFXM135) SFXM135,sum(SFXM136) SFXM136,sum(SFXM137) SFXM137,sum(SFXM138) SFXM138,sum(SFXM139) SFXM139,sum(SFXM140) SFXM140, 
sum(SFXM141) SFXM141,sum(SFXM142) SFXM142,sum(SFXM143) SFXM143,sum(SFXM144) SFXM144,sum(SFXM145) SFXM145,sum(SFXM146) SFXM146,sum(SFXM147) SFXM147,sum(SFXM148) SFXM148,sum(SFXM149) SFXM149,sum(SFXM150) SFXM150, 
sum(SFXM151) SFXM151,sum(SFXM152) SFXM152,sum(SFXM153) SFXM153,sum(SFXM154) SFXM154,sum(SFXM155) SFXM155,sum(SFXM156) SFXM156,sum(SFXM157) SFXM157,sum(SFXM158) SFXM158,sum(SFXM159) SFXM159,sum(SFXM160) SFXM160, 
sum(SFXM161) SFXM161,sum(SFXM162) SFXM162,sum(SFXM163) SFXM163,sum(SFXM164) SFXM164,sum(SFXM165) SFXM165,sum(SFXM166) SFXM166,sum(SFXM167) SFXM167,sum(SFXM168) SFXM168,sum(SFXM169) SFXM169,sum(SFXM170) SFXM170, 
sum(SFXM171) SFXM171,sum(SFXM172) SFXM172,sum(SFXM173) SFXM173,sum(SFXM174) SFXM174,sum(SFXM175) SFXM175,sum(SFXM176) SFXM176,sum(SFXM177) SFXM177,sum(SFXM178) SFXM178,sum(SFXM179) SFXM179,sum(SFXM180) SFXM180, 
sum(SFXM181) SFXM181,sum(SFXM182) SFXM182,sum(SFXM183) SFXM183,sum(SFXM184) SFXM184,sum(SFXM185) SFXM185,sum(SFXM186) SFXM186,sum(SFXM187) SFXM187,sum(SFXM188) SFXM188,sum(SFXM189) SFXM189,sum(SFXM190) SFXM190, 
sum(SFXM191) SFXM191,sum(SFXM192) SFXM192,sum(SFXM193) SFXM193,sum(SFXM194) SFXM194,sum(SFXM195) SFXM195,sum(SFXM196) SFXM196,sum(SFXM197) SFXM197,sum(SFXM198) SFXM198,sum(SFXM199) SFXM199,sum(SFXM200) SFXM200, 
sum(SFXM201) SFXM201,sum(SFXM202) SFXM202,sum(SFXM203) SFXM203,sum(SFXM204) SFXM204,sum(SFXM205) SFXM205,sum(SFXM206) SFXM206,sum(SFXM207) SFXM207,sum(SFXM208) SFXM208,sum(SFXM209) SFXM209,sum(SFXM210) SFXM210, 
sum(SFXM211) SFXM211,sum(SFXM212) SFXM212,sum(SFXM213) SFXM213,sum(SFXM214) SFXM214,sum(SFXM215) SFXM215,sum(SFXM216) SFXM216,sum(SFXM217) SFXM217,sum(SFXM218) SFXM218,sum(SFXM219) SFXM219,sum(SFXM220) SFXM220, 
sum(SFXM221) SFXM221,sum(SFXM222) SFXM222,sum(SFXM223) SFXM223,sum(SFXM224) SFXM224,sum(SFXM225) SFXM225,sum(SFXM226) SFXM226,sum(SFXM227) SFXM227,sum(SFXM228) SFXM228,sum(SFXM229) SFXM229,sum(SFXM230) SFXM230, 
sum(SFXM231) SFXM231,sum(SFXM232) SFXM232,sum(SFXM233) SFXM233,sum(SFXM234) SFXM234,sum(SFXM235) SFXM235,sum(SFXM236) SFXM236,sum(SFXM237) SFXM237,sum(SFXM238) SFXM238,sum(SFXM239) SFXM239,sum(SFXM240) SFXM240, 
sum(SFXM241) SFXM241,sum(SFXM242) SFXM242,sum(SFXM243) SFXM243,sum(SFXM244) SFXM244,sum(SFXM245) SFXM245,sum(SFXM246) SFXM246,sum(SFXM247) SFXM247,sum(SFXM248) SFXM248,sum(SFXM249) SFXM249,sum(SFXM250) SFXM250 
 from  BM_YYSFTJ A,BM_YYSFXM B,BM_FPXM00 C  where  A.BMBH00 = B.SFXMID and B.MZFPID=C.FPXMID  and A.ID0000 =? group by C.XMMC00 
union all 
select ' 总 计' XMMC00,B.SFJE00,A.XMHJ00,A.SFXM01,A.SFXM02,A.SFXM03,A.SFXM04,A.SFXM05,A.SFXM06, 
A.SFXM07,A.SFXM08,A.SFXM09,A.SFXM10,A.SFXM11,A.SFXM12,A.SFXM13,A.SFXM14,A.SFXM15,A.SFXM16,
A.SFXM17,A.SFXM18,A.SFXM19,A.SFXM20,
A.SFXM21,A.SFXM22,A.SFXM23,A.SFXM24,A.SFXM25,A.SFXM26,A.SFXM27,A.SFXM28,A.SFXM29,A.SFXM30,A.SFXM31,
A.SFXM32,A.SFXM33,A.SFXM34,A.SFXM35,A.SFXM36,A.SFXM37,A.SFXM38,A.SFXM39,A.SFXM40,A.SFXM41,A.SFXM42,
A.SFXM43,A.SFXM44,A.SFXM45,A.SFXM46,A.SFXM47,A.SFXM48,A.SFXM49,A.SFXM50,A.SFXM51,A.SFXM52,A.SFXM53,
A.SFXM54,A.SFXM55,A.SFXM56,A.SFXM57,A.SFXM58,A.SFXM59,A.SFXM60,A.SFXM61,A.SFXM62,A.SFXM63,A.SFXM64,
A.SFXM65,A.SFXM66,A.SFXM67,A.SFXM68,A.SFXM69,A.SFXM70,A.SFXM71,A.SFXM72,A.SFXM73,A.SFXM74,A.SFXM75,
A.SFXM76,A.SFXM77,A.SFXM78,A.SFXM79,A.SFXM80,
SFXM81, SFXM82, SFXM83, SFXM84, SFXM85, SFXM86, SFXM87, SFXM88, SFXM89, SFXM90, 
SFXM91, SFXM92, SFXM93, SFXM94, SFXM95, SFXM96, SFXM97, SFXM98, SFXM99, SFXM100, 
SFXM101,SFXM102,SFXM103,SFXM104,SFXM105,SFXM106,SFXM107,SFXM108,SFXM109,SFXM110, 
SFXM111,SFXM112,SFXM113,SFXM114,SFXM115,SFXM116,SFXM117,SFXM118,SFXM119,SFXM120, 
SFXM121,SFXM122,SFXM123,SFXM124,SFXM125,SFXM126,SFXM127,SFXM128,SFXM129,SFXM130, 
SFXM131,SFXM132,SFXM133,SFXM134,SFXM135,SFXM136,SFXM137,SFXM138,SFXM139,SFXM140, 
SFXM141,SFXM142,SFXM143,SFXM144,SFXM145,SFXM146,SFXM147,SFXM148,SFXM149,SFXM150, 
SFXM151,SFXM152,SFXM153,SFXM154,SFXM155,SFXM156,SFXM157,SFXM158,SFXM159,SFXM160, 
SFXM161,SFXM162,SFXM163,SFXM164,SFXM165,SFXM166,SFXM167,SFXM168,SFXM169,SFXM170, 
SFXM171,SFXM172,SFXM173,SFXM174,SFXM175,SFXM176,SFXM177,SFXM178,SFXM179,SFXM180, 
SFXM181,SFXM182,SFXM183,SFXM184,SFXM185,SFXM186,SFXM187,SFXM188,SFXM189,SFXM190, 
SFXM191,SFXM192,SFXM193,SFXM194,SFXM195,SFXM196,SFXM197,SFXM198,SFXM199,SFXM200, 
SFXM201,SFXM202,SFXM203,SFXM204,SFXM205,SFXM206,SFXM207,SFXM208,SFXM209,SFXM210, 
SFXM211,SFXM212,SFXM213,SFXM214,SFXM215,SFXM216,SFXM217,SFXM218,SFXM219,SFXM220, 
SFXM221,SFXM222,SFXM223,SFXM224,SFXM225,SFXM226,SFXM227,SFXM228,SFXM229,SFXM230, 
SFXM231,SFXM232,SFXM233,SFXM234,SFXM235,SFXM236,SFXM237,SFXM238,SFXM239,SFXM240, 
SFXM241,SFXM242,SFXM243,SFXM244,SFXM245,SFXM246,SFXM247,SFXM248,SFXM249,SFXM250 
 from  BM_YYSFTJ A,BM_YYSFXM B  where  A.BMBH00 = B.SFXMID(+) and A.BMBH00=999999999 and A.ID0000 =? 

18      16:51:19  SQL Error: ORACLE - ORA-01467: 分类 (sort) 关键字过长

19      16:51:19  SQL Error: ORACLE - Unmapped SQL Error Code: 1467
20      16:51:19  SQL Data In: ORACLE - Rows affected = 0