1 09:18:05 SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170419 2 09:18:05 SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170419 3 09:18:05 SQL Data In: ORACLE - Param = 3, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 4 09:18:05 SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59 5 09:18:05 SQL Data In: ORACLE - Param = 5, Name = AS_KSMC00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = ËùÓв¡Çø 6 09:18:05 SQL Data In: ORACLE - Param = 6, Name = AS_DWLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 7 09:18:05 SQL Data In: ORACLE - Param = 7, Name = AS_BRLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = -1 8 09:18:05 SQL Data In: ORACLE - Param = 8, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 09:18:05 SQL Data In: ORACLE - Param = 9, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 09:18:05 SQL Data In: ORACLE - Param = 10, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 09:18:05 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 09:18:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4654475.000000 13 09:18:07 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 09:18:07 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4654475.000000 15 09:18:07 SQL Execute: ORACLE - select ID0000,ZYH000,XM0000 from vw_zy_brjsbb_0000001 where ID0000 =? group by ID0000,ZYH000,XM0000 16 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='96' 17 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='01' 18 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='02' 19 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='03' 20 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='04' 21 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='05' 22 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='06' 23 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='07' 24 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='08' 25 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='09' 26 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='10' 27 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='11' 28 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='12' 29 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='13' 30 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='14' 31 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='15' 32 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='16' 33 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='17' 34 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='18' 35 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='19' 36 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='20' 37 09:18:07 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='21' 38 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='22' 39 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='23' 40 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='24' 41 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='25' 42 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='26' 43 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='27' 44 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='28' 45 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='29' 46 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='30' 47 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='31' 48 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='32' 49 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='33' 50 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='34' 51 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='35' 52 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='36' 53 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='37' 54 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='38' 55 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='39' 56 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='40' 57 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='41' 58 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='42' 59 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='43' 60 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='44' 61 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='45' 62 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='46' 63 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='47' 64 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='48' 65 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='49' 66 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='50' 67 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='97' 68 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='98' 69 09:18:08 SQL Execute: ORACLE - select * from BM_BAXM00 where BH0000 ='99'