1 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 2 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5918760.000000 3 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 5 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 7 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 8 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 10 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 11 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 12 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5918761.000000 13 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 14 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 15 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 16 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 17 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 19 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 20 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 21 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 22 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919195.000000 23 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 25 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 26 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 27 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 28 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 29 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 30 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 31 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 32 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919196.000000 33 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 34 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 35 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 36 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 37 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 38 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 39 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 40 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 41 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 42 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919197.000000 43 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 45 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 47 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 50 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 51 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 52 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919194.000000 53 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 54 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 55 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 56 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 57 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 58 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 59 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 60 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 61 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 62 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919192.000000 63 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 67 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 68 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 70 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 71 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 72 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919193.000000 73 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 74 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 75 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 76 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 77 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 78 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 79 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 80 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 81 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 82 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919499.000000 83 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 84 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 85 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 86 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 87 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 88 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 89 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 90 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 91 17:07:05 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 92 17:07:05 SQL Data In: ORACLE - Param = 2, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5919520.000000 93 17:07:05 SQL Data In: ORACLE - Param = 3, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 17:07:05 SQL Data In: ORACLE - Param = 4, Name = P_CSLY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 95 17:07:05 SQL Data In: ORACLE - Param = 5, Name = P_SFXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 17:07:05 SQL Data In: ORACLE - Param = 6, Name = P_BQSFBZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 97 17:07:05 SQL Data In: ORACLE - Param = 7, Name = P_SFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 98 17:07:05 SQL Data In: ORACLE - Param = 8, Name = P_CS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 17:07:05 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 100 17:07:05 SQL Execute: ORACLE - BEGIN "SP_BQ_FJZXXM" (P_MODE00 => :P_MODE00,P_ID0000 => :P_ID0000,P_YZID00 => :P_YZID00,P_CSLY00 => :P_CSLY00,P_SFXMID => :P_SFXMID,P_BQSFBZ => :P_BQSFBZ,P_SFJE00 => :P_SFJE00,P_CS0000 => :P_CS0000,P_CZY000 => :P_CZY000); END; 101 17:07:05 SQL Execute: ORACLE - Commit 102 17:07:05 SQL Data In: ORACLE - Rows affected = 0 103 17:07:05 SQL Execute: ORACLE - select * from VW_BQ_YPYZJE where YZID00 = '12230705' order by YZMXID 104 17:07:05 SQL Execute: ORACLE - select * from VW_BQ_FJZXXM where YZID00 = '12230705' and CSLY00 in ('0','1','3') and TZRQ00 is null Order By LRSJ00