1       11:31:23  SQL Execute: ORACLE - select  distinct  (ZWXM00||'_'||XKH000) CZYXM0  from  VW_SF_SFY000  

2       11:31:27  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140211
3       11:31:27  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
4       11:31:27  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140211
5       11:31:27  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
6       11:31:27  SQL Data In: ORACLE - Param = 5, Name = AS_SFY000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有收费员
7       11:31:27  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
8       11:31:27  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
9       11:31:27  SQL Data In: ORACLE - Param = 8, Name = AS_JKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      11:31:27  SQL Data In: ORACLE - Param = 9, Name = AS_SFASFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
11      11:31:27  SQL Execute: ORACLE - BEGIN "SP_SF_SFYJK0_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_SFY000 => :AS_SFY000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JKDH00 => :AS_JKDH00,AS_SFASFY => :AS_SFASFY); END;
12      11:31:35  SQL Execute: ORACLE -  select * from  VW_SF_SFYJKB  where  JKDH00 = 58526
and (PJHJJE<>0 or HSZFJE<>0 or JKJE00<>0) order by CZYXM0

13      11:31:35  SQL Execute: ORACLE - rollback

14      11:31:35  SQL Data In: ORACLE - Rows affected = 0
15      12:25:54  SQL Execute: ORACLE - select  distinct  (ZWXM00||'_'||XKH000) CZYXM0  from  VW_SF_SFY000  

16      12:26:01  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140211
17      12:26:01  SQL Data In: ORACLE - Param = 2, Name = AS_KSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00
18      12:26:01  SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140211
19      12:26:01  SQL Data In: ORACLE - Param = 4, Name = AS_JSSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 23:59:59
20      12:26:01  SQL Data In: ORACLE - Param = 5, Name = AS_SFY000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 所有收费员
21      12:26:01  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
22      12:26:01  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
23      12:26:01  SQL Data In: ORACLE - Param = 8, Name = AS_JKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
24      12:26:01  SQL Data In: ORACLE - Param = 9, Name = AS_SFASFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y
25      12:26:01  SQL Execute: ORACLE - BEGIN "SP_SF_SFYJK0_RBB000" (AS_KSRQ00 => :AS_KSRQ00,AS_KSSJ00 => :AS_KSSJ00,AS_JSRQ00 => :AS_JSRQ00,AS_JSSJ00 => :AS_JSSJ00,AS_SFY000 => :AS_SFY000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_JKDH00 => :AS_JKDH00,AS_SFASFY => :AS_SFASFY); END;
26      12:26:02  SQL Execute: ORACLE -  select * from  VW_SF_SFYJKB  where  JKDH00 = 58531
and (PJHJJE<>0 or HSZFJE<>0 or JKJE00<>0) order by CZYXM0

27      12:26:02  SQL Execute: ORACLE - rollback

28      12:26:02  SQL Data In: ORACLE - Rows affected = 0