1 09:48:36 SQL Execute: ORACLE - select DLBQZX from BM_ZLZD00 where ZLXMID = 21641 2 09:48:36 SQL Execute: ORACLE - select distinct JSXMKS,JSKSMC from VW_XT_XMFWFX_ZXKS where ZLXMID = 21641 and SQXMKS = 663 3 09:48:36 SQL Execute: ORACLE - select distinct ZXKSBH,ZXKSMC from VW_XT_KSZXXM_ZXKS where ZLXMID = 21641 4 09:48:36 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5 09:48:36 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 09:48:36 SQL Data In: ORACLE - Param = 3, Name = P_ZYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 760502 7 09:48:36 SQL Data In: ORACLE - Param = 4, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 8 09:48:36 SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 9 09:48:36 SQL Data In: ORACLE - Param = 6, Name = P_PXSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:48:34 10 09:48:36 SQL Data In: ORACLE - Param = 7, Name = P_ZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 21641.000000 11 09:48:36 SQL Data In: ORACLE - Param = 8, Name = P_ZLXMMC, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 血气分析 12 09:48:36 SQL Data In: ORACLE - Param = 9, Name = P_ZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 498.000000 13 09:48:36 SQL Data In: ORACLE - Param = 10, Name = P_KZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1496.000000 14 09:48:36 SQL Data In: ORACLE - Param = 11, Name = P_LRRXM0, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 郑力 15 09:48:36 SQL Data In: ORACLE - Param = 12, Name = P_QYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150416 16 09:48:36 SQL Data In: ORACLE - Param = 13, Name = P_QYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:47:00 17 09:48:36 SQL Data In: ORACLE - Param = 14, Name = P_TS0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 18 09:48:36 SQL Data In: ORACLE - Param = 15, Name = P_PCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 19 09:48:36 SQL Data In: ORACLE - Param = 16, Name = P_MCSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 20 09:48:36 SQL Data In: ORACLE - Param = 17, Name = P_TQFS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 21 09:48:36 SQL Data In: ORACLE - Param = 18, Name = P_YZCLLB, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 正常 22 09:48:36 SQL Data In: ORACLE - Param = 19, Name = P_BZ0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 23 09:48:36 SQL Data In: ORACLE - Param = 20, Name = P_ZDID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 24 09:48:36 SQL Data In: ORACLE - Param = 21, Name = P_ZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 25 09:48:36 SQL Data In: ORACLE - Param = 22, Name = P_BQZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 26 09:48:36 SQL Data In: ORACLE - Param = 23, Name = P_BWMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 27 09:48:36 SQL Data In: ORACLE - Param = 24, Name = P_BB0000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 28 09:48:36 SQL Data In: ORACLE - Param = 25, Name = P_BBID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 29 09:48:36 SQL Data In: ORACLE - Param = 26, Name = P_SFSQD0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 30 09:48:36 SQL Data In: ORACLE - Param = 27, Name = P_ZXYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 31 09:48:36 SQL Data In: ORACLE - Param = 28, Name = P_CJKS00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 32 09:48:36 SQL Data In: ORACLE - Param = 29, Name = P_LJID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 33 09:48:36 SQL Data In: ORACLE - Param = 30, Name = P_RCID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 34 09:48:36 SQL Data In: ORACLE - Param = 31, Name = P_ZXID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 35 09:48:36 SQL Execute: ORACLE - BEGIN "SP_ZS_YJYZ00" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_ZYID00 => :P_ZYID00,P_YEXM00 => :P_YEXM00,P_CLBZ00 => :P_CLBZ00,P_PXSJ00 => :P_PXSJ00,P_ZLXMID => :P_ZLXMID,P_ZLXMMC => :P_ZLXMMC,P_ZXKS00 => :P_ZXKS00,P_KZYS00 => :P_KZYS00,P_LRRXM0 => :P_LRRXM0,P_QYRQ00 => :P_QYRQ00,P_QYSJ00 => :P_QYSJ00,P_TS0000 => :P_TS0000,P_PCID00 => :P_PCID00,P_MCSL00 => :P_MCSL00,P_TQFS00 => :P_TQFS00,P_YZCLLB => :P_YZCLLB,P_BZ0000 => :P_BZ0000,P_ZDID00 => :P_ZDID00,P_ZDMC00 => :P_ZDMC00,P_BQZY00 => :P_BQZY00,P_BWMC00 => :P_BWMC00,P_BB0000 => :P_BB0000,P_BBID00 => :P_BBID00,P_SFSQD0 => :P_SFSQD0,P_ZXYS00 => :P_ZXYS00,P_CJKS00 => :P_CJKS00,P_LJID00 => :P_LJID00,P_RCID00 => :P_RCID00,P_ZXID00 => :P_ZXID00); END; 36 09:48:36 SQL Data In: ORACLE - Param = 1, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15814212.000000 37 09:48:36 SQL Data In: ORACLE - Param = 2, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 38 09:48:36 SQL Execute: ORACLE - BEGIN "SP_BQ_YJFJFY" (P_YZMXID => :P_YZMXID,P_CZY000 => :P_CZY000); END; 39 09:48:36 SQL Execute: ORACLE - Commit 40 09:48:36 SQL Data In: ORACLE - Rows affected = 0 41 09:48:36 SQL Execute: ORACLE - select * from VW_ZS_LJBYYZ where ZYID00=760502 and YZXZLX='0' and (ZTID00 not in(2,3,4) or TLBYBZ=1) and YZZT00 in ('7','10') and INIBZ0=1 and nvl(BYYY00,' ')=' ' and ZXJSRQ<='20150416' and DQJDBZ in ('0','2') 42 09:48:36 SQL Execute: ORACLE - select count(*) from VW_ZS_LJBYYZ where YZXZLX='0' and ZYID00=760502and INIBZ0=1 and (ZTID00 not in(2,3,4) or TLBYBZ=1) and YZZT00 in('7','10') and nvl(BYYY00,' ')=' ' and ZXJSRQ<='20150416' and INIBZ0=1 and DQJDBZ in ('0','2') 43 09:48:36 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 760502 and CLBZ00 = '1' and LB0000 = '1' and YZLB00 = '4' and (YZZT00 in ('7','0','1','2','5','9','7','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 44 09:48:37 SQL Execute: ORACLE - select 'N' XZ0000,A.ZLXMID,A.ZLXMJC, D.CKZ000, ' ' JGSM00, D.JGDW00 , a.ZFBL00 FROM VW_BQ_YBFYYZ a, XT_kszxxm b , VW_BM_ZLZD00 d where a.ZLXMID=D.ZLXMID and a.ZLXMID=b.ZLXMID and a.LBBH00='4' AND A.ZYZBID='5' and ((a.YBZXLB='1' and a.YBBRLB='3' and a.FBBH00='3') or (SFSFXM='N')) order by b.KSXMID 45 09:48:37 SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00 46 09:48:37 SQL Execute: ORACLE - select to_date('2015.04.16','YYYY.MM.DD') QYRQ, to_date('09:48','HH24:MI:SS') QYSJ FROM DUAL 47 09:48:48 SQL Execute: ORACLE - select * from VW_ZS_LJBYYZ where ZYID00=760502 and YZXZLX='0' and (ZTID00 not in(2,3,4) or TLBYBZ=1) and YZZT00 in ('7','10') and INIBZ0=1 and nvl(BYYY00,' ')=' ' and ZXJSRQ<='20150416' and DQJDBZ in ('0','2') 48 09:48:48 SQL Execute: ORACLE - select count(*) from VW_ZS_LJBYYZ where YZXZLX='0' and ZYID00=760502and INIBZ0=1 and (ZTID00 not in(2,3,4) or TLBYBZ=1) and YZZT00 in('7','10') and nvl(BYYY00,' ')=' ' and ZXJSRQ<='20150416' and INIBZ0=1 and DQJDBZ in ('0','2') 49 09:48:48 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 50 09:48:48 SQL Data In: ORACLE - Param = 2, Name = P_YZMXID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 15814212.000000 51 09:48:48 SQL Data In: ORACLE - Param = 3, Name = P_HDRXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 52 09:48:48 SQL Data In: ORACLE - Param = 4, Name = P_TZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 53 09:48:48 SQL Data In: ORACLE - Param = 5, Name = P_TZRXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 54 09:48:48 SQL Data In: ORACLE - Param = 6, Name = P_TZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 55 09:48:48 SQL Data In: ORACLE - Param = 7, Name = P_TZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 56 09:48:48 SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 57 09:48:48 SQL Data In: ORACLE - Param = 9, Name = P_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 58 09:48:48 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZQT" (P_MODE00 => :P_MODE00,P_YZMXID => :P_YZMXID,P_HDRXM0 => :P_HDRXM0,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00,P_CZY000 => :P_CZY000); END; 59 09:48:49 SQL Execute: ORACLE - Commit 60 09:48:49 SQL Data In: ORACLE - Rows affected = 0 61 09:48:49 SQL Execute: ORACLE - select SFXYTZ from bm_zlzd00 where zlxmid in (SELECT ZLXMID FROM BQ_YJYZ00 WHERE YZMXID=15814212) 62 09:48:49 SQL Execute: ORACLE - SELECT TZLBID,TZLBMC,DW0000 FROM BQ_TZLB00 where TZLBID IN (0,2,3) 63 09:49:00 SQL Execute: ORACLE - Insert into bq_brtzxx (ID0000, ZYID00, TZLBID, JLRQ00, JLSJ00, SZ0000, LRR000, LRRQ00, LRSJ00 ) values (sq_bq_brtzxx_id0000.NEXTVAL, 760502,0, TO_CHAR(SYSDATE,'YYYYMMDD'),to_char(sysdate,'HH24'),'37',1496,TO_CHAR(SYSDATE,'YYYYMMDD'), TO_CHAR(SYSDATE,'HH24:MI:SS') ) 64 09:49:00 SQL Data In: ORACLE - Rows affected = 1 65 09:49:00 SQL Execute: ORACLE - Commit 66 09:49:00 SQL Data In: ORACLE - Rows affected = 0 67 09:49:00 SQL Execute: ORACLE - Insert into bq_brtzxx (ID0000, ZYID00, TZLBID, JLRQ00, JLSJ00, SZ0000, LRR000, LRRQ00, LRSJ00 ) values (sq_bq_brtzxx_id0000.NEXTVAL, 760502,2, TO_CHAR(SYSDATE,'YYYYMMDD'),to_char(sysdate,'HH24'),'29',1496,TO_CHAR(SYSDATE,'YYYYMMDD'), TO_CHAR(SYSDATE,'HH24:MI:SS') ) 68 09:49:00 SQL Error: ORACLE - ORA-00001: 违反唯一约束条件 (SD_BQ.UQ_BQ_BRTZXX_ZYIDJL) 69 09:49:00 SQL Data In: ORACLE - Rows affected = 0 70 09:49:00 SQL Execute: ORACLE - RollBack 71 09:49:00 SQL Data In: ORACLE - Rows affected = 0 72 09:50:13 SQL Execute: ORACLE - select * from VW_ZS_YZLL00 where ZYID00 = 760502 and CLBZ00 = '1' and LB0000 = '1' and YZLB00 = '4' and (YZZT00 in ('7','0','1','2','5','9','7','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,LRRQ00,PXSJ00,YZID00,YZMXID 73 09:50:39 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1