1 16:15:42 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120101 2 16:15:42 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120903 3 16:15:42 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 4 16:15:42 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 5 16:15:42 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = ËùÓв¡Çø 6 16:15:42 SQL Data In: ORACLE - Param = 6, Name = AS_DWLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 16:15:42 SQL Data In: ORACLE - Param = 7, Name = AS_BRLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 8 16:15:42 SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 16:15:42 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 16:15:42 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 16:15:42 SQL Execute: ORACLE - BEGIN "SP_ZY_CYBRFY_BABB00" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSSJ00 => :AS_JSSJ00,AS_KSMC00 => :AS_KSMC00,AS_DWLB00 => :AS_DWLB00,AS_BRLB00 => :AS_BRLB00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 12 16:16:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3126297.000000 13 16:16:29 SQL Execute: ORACLE - select ID0000,ZYH000,ZYID00,max(BMMC00)BMMC00,XM0000,max(FBMC00) FBMC00,max(trim(RYCWH0))RYCWH0,max(BRGFZH)BRGFZH,max(CYDJYS)CYDJYS,max(JZY000)JZY000, max(CYRQ00)CYRQ00,max(ZYTS00)ZYTS00,sum(XMHJ00)XMHJ00,round(nvl(sum(YPHJ00),0)*100/decode(nvl(sum(XMHJ00),0),0,1,nvl(sum(XMHJ00),0)),2) SFXM96, sum(SFXM01)SFXM01,sum(SFXM02)SFXM02,sum(SFXM03)SFXM03,sum(SFXM04)SFXM04,sum(SFXM05)SFXM05, sum(SFXM06)SFXM06,sum(SFXM07)SFXM07,sum(SFXM08)SFXM08,sum(SFXM09)SFXM09,sum(SFXM10)SFXM10, sum(SFXM11)SFXM11,sum(SFXM12)SFXM12,sum(SFXM13)SFXM13,sum(SFXM14)SFXM14,sum(SFXM15)SFXM15, sum(SFXM16)SFXM16,sum(SFXM17)SFXM17,sum(SFXM18)SFXM18,sum(SFXM19)SFXM19,sum(SFXM20)SFXM20, sum(SFXM21)SFXM21,sum(SFXM22)SFXM22,sum(SFXM23)SFXM23,sum(SFXM24)SFXM24,sum(SFXM25)SFXM25, sum(SFXM26)SFXM26,sum(SFXM27)SFXM27,sum(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(SFXM97)SFXM97,SUM(SFXM98)SFXM98,SUM(SFXM99)SFXM99 from vw_zy_brjsbb_0000001 where ID0000 =? group by ID0000,ZYH000,XM0000,ZYID00 order by ZYH000 14 16:16:29 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3126297.000000 15 16:16:29 SQL Execute: ORACLE - select ID0000,ZYH000,XM0000 from vw_zy_brjsbb_0000001 where ID0000 =? group by ID0000,ZYH000,XM0000 16 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='96' 17 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='01' 18 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='02' 19 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='03' 20 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='04' 21 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='05' 22 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='06' 23 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='07' 24 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='08' 25 16:16:29 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='09' 26 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='10' 27 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='11' 28 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='12' 29 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='13' 30 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='14' 31 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='15' 32 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='16' 33 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='17' 34 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='18' 35 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='19' 36 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='20' 37 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='21' 38 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='22' 39 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='23' 40 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='24' 41 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='25' 42 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='26' 43 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='27' 44 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='28' 45 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='29' 46 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='30' 47 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='31' 48 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='32' 49 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='33' 50 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='34' 51 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='35' 52 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='36' 53 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='37' 54 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='38' 55 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='39' 56 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='40' 57 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='41' 58 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='42' 59 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='43' 60 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='44' 61 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='45' 62 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='46' 63 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='47' 64 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='48' 65 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='49' 66 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='50' 67 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='97' 68 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='98' 69 16:16:30 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='99'