1 10:19:44 SQL Stmt: ORACLE - Close 2 10:19:44 SQL Prepare: ORACLE - SELECT DISTINCT Q.YFBMBH,Q.ZYH000,Q.CH0000,Q.BRXM00,Q.ZYID00 FROM YF_YZYPSQ Q WHERE Q.YFBMBH=497 AND Q.BQBMBH=663 AND Q.QLZT00='0' AND CXBZ00='-' ORDER BY CH0000 3 10:19:44 SQL Execute: ORACLE - SELECT DISTINCT Q.YFBMBH,Q.ZYH000,Q.CH0000,Q.BRXM00,Q.ZYID00 FROM YF_YZYPSQ Q WHERE Q.YFBMBH=497 AND Q.BQBMBH=663 AND Q.QLZT00='0' AND CXBZ00='-' ORDER BY CH0000 4 10:19:44 SQL Misc: ORACLE - Set rowset size 5 10:19:44 SQL Stmt: ORACLE - Fetch 6 10:19:44 SQL Stmt: ORACLE - EOF 7 10:19:44 SQL Data Out: ORACLE - Column = 1, Name = YFBMBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 497.000000 8 10:19:44 SQL Data Out: ORACLE - Column = 2, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 1501770 9 10:19:44 SQL Data Out: ORACLE - Column = 3, Name = CH0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = ÄÚ·ÖÃÚ23 10 10:19:44 SQL Data Out: ORACLE - Column = 4, Name = BRXM00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = ÷־Ӣ 11 10:19:44 SQL Data Out: ORACLE - Column = 5, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 760976.000000 12 10:19:44 SQL Stmt: ORACLE - Reset 13 10:19:44 SQL Prepare: ORACLE - BEGIN "SP_YF_BQTYSQQR" (P_ZYH000 => :P_ZYH000,P_LYCZY0 => :P_LYCZY0,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_OUT_CKDH => :P_OUT_CKDH); END; 14 10:19:44 SQL Misc: ORACLE - Set stored procedure on or off 15 10:19:44 SQL Data In: ORACLE - Param = 1, Name = P_ZYH000, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1501770 16 10:19:44 SQL Data In: ORACLE - Param = 2, Name = P_LYCZY0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1660.000000 17 10:19:44 SQL Data In: ORACLE - Param = 3, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1660.000000 18 10:19:44 SQL Data In: ORACLE - Param = 4, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1660.000000 19 10:19:44 SQL Data In: ORACLE - Param = 5, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497.000000 20 10:19:44 SQL Data In: ORACLE - Param = 6, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 663.000000 21 10:19:44 SQL Data In: ORACLE - Param = 7, Name = P_OUT_CKDH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 10:19:44 SQL Execute: ORACLE - BEGIN "SP_YF_BQTYSQQR" (P_ZYH000 => :P_ZYH000,P_LYCZY0 => :P_LYCZY0,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_OUT_CKDH => :P_OUT_CKDH); END; 23 10:19:45 SQL Stmt: ORACLE - Close 24 10:19:45 SQL Transact: ORACLE - XACT Commit 25 10:19:45 SQL Prepare: ORACLE - COMMIT WORK 26 10:19:45 SQL Execute: ORACLE - COMMIT WORK 27 10:19:45 SQL Stmt: ORACLE - Close 28 10:19:46 SQL Stmt: ORACLE - Close 29 10:19:46 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 30 10:19:46 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 31 10:19:46 SQL Misc: ORACLE - Set rowset size 32 10:19:46 SQL Stmt: ORACLE - Fetch 33 10:19:46 SQL Stmt: ORACLE - EOF 34 10:19:46 SQL Data Out: ORACLE - Column = 1, Name = ORASYSDATE, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150513 35 10:19:46 SQL Stmt: ORACLE - Close 36 10:19:46 SQL Prepare: ORACLE - SELECT Q.YPNM00,Q.YPMC00,Q.YPGG00,Q.QLDW00,Q.LSDJ00,SUM(Q.YPZSL0) YPZSL0 FROM YF_YZYPSQ Q WHERE Q.YFBMBH=497 AND Q.BQBMBH=663 AND Q.QLZT00='0' AND CXBZ00='-' group by Q.YPNM00,Q.YPMC00,Q.YPGG00,Q.QLDW00,Q.LSDJ00 ORDER BY Q.YPNM00 37 10:19:46 SQL Execute: ORACLE - SELECT Q.YPNM00,Q.YPMC00,Q.YPGG00,Q.QLDW00,Q.LSDJ00,SUM(Q.YPZSL0) YPZSL0 FROM YF_YZYPSQ Q WHERE Q.YFBMBH=497 AND Q.BQBMBH=663 AND Q.QLZT00='0' AND CXBZ00='-' group by Q.YPNM00,Q.YPMC00,Q.YPGG00,Q.QLDW00,Q.LSDJ00 ORDER BY Q.YPNM00 38 10:19:46 SQL Misc: ORACLE - Set rowset size 39 10:19:46 SQL Stmt: ORACLE - Fetch 40 10:19:46 SQL Stmt: ORACLE - EOF 41 10:19:46 SQL Stmt: ORACLE - Reset