1 15:23:29 SQL Prepare: ORACLE - Select '00' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 2 15:23:29 SQL Execute: ORACLE - Select '00' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 3 15:23:29 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 4 15:23:29 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 5 15:23:29 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 6 15:23:29 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 7 15:23:29 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 8 15:23:29 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 9 15:23:29 SQL Error: ORACLE - ORA-00942: 表或视图不存在 10 15:23:29 SQL Data In: ORACLE - Rows affected = 0 11 15:23:30 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090506' 12 15:23:30 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090506' 13 15:23:30 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=332848 14 15:23:30 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=332848 15 15:23:30 SQL Data In: ORACLE - Rows affected = 1 16 15:23:30 SQL Prepare: ORACLE - Commit 17 15:23:30 SQL Execute: ORACLE - Commit 18 15:23:30 SQL Data In: ORACLE - Rows affected = 0 19 15:23:30 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00= 20 15:23:30 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00= 21 15:23:30 SQL Error: ORACLE - ORA-00921: 未预期的 SQL 命令结尾 22 15:23:30 SQL Error: ORACLE - Unmapped SQL Error Code: 921 23 15:23:30 SQL Data In: ORACLE - Rows affected = 0 24 15:23:30 SQL Prepare: ORACLE - RollBack 25 15:23:30 SQL Execute: ORACLE - RollBack 26 15:23:30 SQL Data In: ORACLE - Rows affected = 0 27 15:23:30 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 28 15:23:30 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 29 15:23:30 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 30 15:23:30 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 31 15:23:30 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(332852,1,'STARTCHUGE','6',nvl('142578',' '),'',15) 32 15:23:30 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(332852,1,'STARTCHUGE','6',nvl('142578',' '),'',15) 33 15:23:30 SQL Data In: ORACLE - Rows affected = 1 34 15:23:30 SQL Prepare: ORACLE - Commit 35 15:23:30 SQL Execute: ORACLE - Commit 36 15:23:30 SQL Data In: ORACLE - Rows affected = 0 37 15:23:30 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='6' and (( 1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) 38 15:23:30 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='6' and (( 1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) 39 15:23:31 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 40 15:23:31 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 41 15:23:31 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) 42 15:23:31 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 1= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1)))) 43 15:25:54 SQL Prepare: ORACLE - select * from XT_BMXZ00 44 15:25:54 SQL Execute: ORACLE - select * from XT_BMXZ00 45 15:25:54 SQL Prepare: ORACLE - Select * from BM_BMBM00 order by BH0000 46 15:25:54 SQL Execute: ORACLE - Select * from BM_BMBM00 order by BH0000 47 15:31:14 Log started for: 项目管理系统 48 15:31:14 SQL Execute: ORACLE - Select * from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 49 15:31:14 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '10.140.151.77','C',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 50 15:31:14 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial) Select '10.140.151.77','C',PROGRAM,SID,serial# from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 51 15:31:14 SQL Data In: ORACLE - Rows affected = 1 52 15:31:14 SQL Prepare: ORACLE - Commit 53 15:31:14 SQL Execute: ORACLE - Commit 54 15:31:14 SQL Data In: ORACLE - Rows affected = 0 55 15:31:14 SQL Prepare: ORACLE - Select SYSDATE from Dual 56 15:31:14 SQL Execute: ORACLE - Select SYSDATE from Dual 57 15:31:14 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 58 15:31:14 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 59 15:31:14 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='C' 60 15:31:14 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='C' 61 15:31:14 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 62 15:31:14 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 63 15:31:14 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 64 15:31:14 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 65 15:31:14 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='C' 66 15:31:14 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='C' 67 15:31:16 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('6','8','a') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 68 15:31:16 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('6','8','a') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='C' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) order by BH0000 69 15:31:16 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'C' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 70 15:31:16 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'C' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 71 15:31:16 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 72 15:31:16 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 73 15:31:16 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 74 15:31:16 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 75 15:31:16 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 76 15:31:16 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 77 15:31:16 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 78 15:31:16 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 79 15:31:16 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 80 15:31:16 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 81 15:31:16 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 732 and FLAG00 like '%' order by decode(CKBH00,17,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 82 15:31:16 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 732 and FLAG00 like '%' order by decode(CKBH00,17,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 83 15:31:16 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 84 15:31:16 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 85 15:31:16 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 86 15:31:16 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 87 15:31:16 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(353009,1513,'STARTCHUGE','C',nvl('7912',' '),'',732) 88 15:31:16 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(353009,1513,'STARTCHUGE','C',nvl('7912',' '),'',732) 89 15:31:16 SQL Data In: ORACLE - Rows affected = 1 90 15:31:16 SQL Prepare: ORACLE - Commit 91 15:31:16 SQL Execute: ORACLE - Commit 92 15:31:16 SQL Data In: ORACLE - Rows affected = 0 93 15:31:16 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 732 94 15:31:16 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 732 95 15:31:16 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='C') and YXQ000>='20090506' 96 15:31:16 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='C') and YXQ000>='20090506' 97 15:31:16 SQL Prepare: ORACLE - Select SYSDATE from Dual 98 15:31:16 SQL Execute: ORACLE - Select SYSDATE from Dual 99 15:31:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 100 15:31:16 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='C' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 101 15:31:16 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'C$%' and A.XTDM00='C' and trim(A.MKDM00)='C$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 102 15:31:16 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'C$%' and A.XTDM00='C' and trim(A.MKDM00)='C$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 103 15:31:16 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 104 15:31:16 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='0' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 105 15:31:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 106 15:31:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 107 15:31:16 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 108 15:31:16 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 109 15:31:16 SQL Prepare: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_SFGL' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 110 15:31:16 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_SFGL' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 111 15:31:16 SQL Prepare: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_CLGL' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 112 15:31:16 SQL Execute: ORACLE - select 1 from XT_XTMK00 where XTDM00='C' and MKNBMC='YY_CLGL' and (( 1513= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='C' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=1513)))) 113 15:31:16 SQL Prepare: ORACLE - select yydj00 from xt_yyxx00 where yyid00='220034' 114 15:31:16 SQL Execute: ORACLE - select yydj00 from xt_yyxx00 where yyid00='220034' 115 15:31:16 SQL Prepare: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 116 15:31:16 SQL Execute: ORACLE - select VALUE0 from xt_xtcs00 where NAME00='XT_SYDWXZ' 117 15:31:16 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 118 15:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 119 15:31:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 15, Scale = 0, Data = XM_ZXGXXLH_ID00 120 15:31:16 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 121 15:31:16 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 122 15:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 123 15:31:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_HZSRF 124 15:31:16 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 125 15:31:16 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 126 15:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 127 15:31:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_SRXG0 128 15:31:16 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 129 15:31:16 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 130 15:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 131 15:31:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_PPFX0 132 15:31:16 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 133 15:31:16 SQL Prepare: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=:1 and rtrim(ltrim(name00))=:2 134 15:31:16 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1513.000000 135 15:31:16 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = XM_ZDJLS 136 15:31:16 SQL Execute: ORACLE - select count(*) as datcnt from xt_yhcs00 where ygbh00=? and rtrim(ltrim(name00))=? 137 15:31:16 SQL Prepare: ORACLE - select name00,value0 from xt_yhcs00 where ygbh00=1513 order by name00 138 15:31:16 SQL Execute: ORACLE - select name00,value0 from xt_yhcs00 where ygbh00=1513 order by name00 139 15:31:27 SQL Prepare: ORACLE - select FBBH00,FBMC00 From BM_BRFBB0 where SFYX00='Y' and FBBH00 in (3,90) order by FBBH00 140 15:31:27 SQL Execute: ORACLE - select FBBH00,FBMC00 From BM_BRFBB0 where SFYX00='Y' and FBBH00 in (3,90) order by FBBH00 141 15:31:27 SQL Prepare: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=:1 and yblb00=ybzxlb and yblb00<>'0' 142 15:31:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 143 15:31:27 SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=? and yblb00=ybzxlb and yblb00<>'0' 144 15:31:27 SQL Prepare: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=:1) and (ybzxlb=:2) and (xmbh00 like :3) and (sfybxm like :4) and (sfyx00 like :5) order by xmbh00 145 15:31:27 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 146 15:31:27 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 147 15:31:27 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 148 15:31:27 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 149 15:31:27 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 150 15:31:27 SQL Execute: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=?) and (ybzxlb=?) and (xmbh00 like ?) and (sfybxm like ?) and (sfyx00 like ?) order by xmbh00 151 15:31:29 SQL Error: ORACLE - ORA-01427: 单行子查询返回多于一个行 152 15:31:29 SQL Error: ORACLE - Unmapped SQL Error Code: 1427 153 15:31:29 SQL Data In: ORACLE - Rows affected = 0 154 15:31:30 SQL Prepare: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' and ybzxlb=:1 and FBBH00=:2 155 15:31:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 156 15:31:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 157 15:31:30 SQL Execute: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' and ybzxlb=? and FBBH00=? 158 15:31:30 SQL Prepare: ORACLE - select ybbrlb from bm_ybbrlb where FBBH00=:1 and ybzxlb=:2 159 15:31:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 160 15:31:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 161 15:31:30 SQL Execute: ORACLE - select ybbrlb from bm_ybbrlb where FBBH00=? and ybzxlb=? 162 15:31:32 SQL Prepare: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=:1) and (ybzxlb=:2) and (xmbh00 like :3) and (sfybxm like :4) and (sfyx00 like :5) order by xmbh00 163 15:31:32 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 164 15:31:32 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 165 15:31:32 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 166 15:31:32 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 167 15:31:32 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 168 15:31:32 SQL Execute: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=?) and (ybzxlb=?) and (xmbh00 like ?) and (sfybxm like ?) and (sfyx00 like ?) order by xmbh00 169 15:31:33 SQL Error: ORACLE - ORA-01427: 单行子查询返回多于一个行 170 15:31:33 SQL Error: ORACLE - Unmapped SQL Error Code: 1427 171 15:31:33 SQL Data In: ORACLE - Rows affected = 0 172 15:39:39 SQL Prepare: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=:1) and (ybzxlb=:2) and (xmbh00 like :3) and (sfybxm like :4) and (sfyx00 like :5) order by xmbh00 173 15:39:39 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 174 15:39:39 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 175 15:39:39 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 176 15:39:39 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 177 15:39:39 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 178 15:39:39 SQL Execute: ORACLE - select FBBH00,FLAG00,xmmc00,xmbh00,ZYFPXM,ZYMC00,MZFPXM,MZMC00,YPJX00,XMDW00,ZFBL00,PYSM00,WBSM00,GXXLH0, sfyx00,decode(sfyx00,'Y','有效','N','无效')sfywxd, YBLB00,(select YBLBMC from BM_YBLB00 where YBLB00=a.YBLB00) yblblb, SFYBXM,decode(SFYBXM,'Y','医保项目','N','非医保项目')sfxm00, decode(flag00,'0','类别','1','项目')flag,YBZXLB,ybbrlb,SFSX00,SCCJ00,YPGG00,BZ0000 from VW_BM_YBSFFPXMGL a where (FBBH00=?) and (ybzxlb=?) and (xmbh00 like ?) and (sfybxm like ?) and (sfyx00 like ?) order by xmbh00 179 15:39:42 SQL Prepare: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' and ybzxlb=:1 and FBBH00=:2 180 15:39:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 181 15:39:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 182 15:39:42 SQL Execute: ORACLE - select flag00,xmbh00,xmmc00 from bm_ybsfxm where flag00='0' and ybzxlb=? and FBBH00=? 183 15:43:41 SQL Prepare: ORACLE - select * from bm_bmgz00 a where exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0') or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0') order by BMGZSH 184 15:43:41 SQL Execute: ORACLE - select * from bm_bmgz00 a where exists(select 1 from BM_YYSFXM where bmgzid=a.bmgzid and flag00='0') or exists(select 1 from BM_SFXMBZ where bmgzid=a.bmgzid and flag00='0') order by BMGZSH 185 15:43:42 SQL Prepare: ORACLE - select * from bm_bmgz00 a where bmgzid=1 order by BMGZSH 186 15:43:42 SQL Execute: ORACLE - select * from bm_bmgz00 a where bmgzid=1 order by BMGZSH 187 15:43:42 SQL Prepare: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 188 15:43:42 SQL Execute: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 189 15:43:42 SQL Prepare: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 190 15:43:42 SQL Execute: ORACLE - select FBBH00,FBMC00 from bm_BRFBB0 where FBBH00>=3 191 15:43:42 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YBMZFP,YBZYFP FROM VW_BM_NOTINYYDYZYST ORDER BY SFXMID 192 15:43:42 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YBMZFP,YBZYFP FROM VW_BM_NOTINYYDYZYST ORDER BY SFXMID 193 15:43:43 SQL Prepare: ORACLE - select count(*) as cnt000 from VW_BM_YBSFDY_SCXMDEL 194 15:43:43 SQL Execute: ORACLE - select count(*) as cnt000 from VW_BM_YBSFDY_SCXMDEL 195 15:43:44 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 196 15:43:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 197 15:43:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 198 15:43:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 199 15:43:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 200 15:43:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 201 15:43:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 202 15:43:44 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 203 15:43:44 SQL Prepare: ORACLE - Select bh0000,xmmc00,flag00,zjbz00 from bm_yysfxm where bmgzid=:1 and flag00='0' and sfxmid<9000000000 and ((:2 = 0) or (:3 = 1 and not(bmgzid=1 and BH0000 like '9%')) or (:4 = 2 and bmgzid=1 and BH0000 like '9%')) order by bh0000 204 15:43:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 205 15:43:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 206 15:43:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 207 15:43:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 208 15:43:44 SQL Execute: ORACLE - Select bh0000,xmmc00,flag00,zjbz00 from bm_yysfxm where bmgzid=? and flag00='0' and sfxmid<9000000000 and ((? = 0) or (? = 1 and not(bmgzid=1 and BH0000 like '9%')) or (? = 2 and bmgzid=1 and BH0000 like '9%')) order by bh0000 209 15:43:47 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 210 15:43:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 211 15:43:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 212 15:43:47 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 213 15:43:47 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 214 15:43:47 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 215 15:43:47 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 216 15:43:47 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 217 15:43:48 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 218 15:43:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 219 15:43:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 220 15:43:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 221 15:43:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 01% 222 15:43:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 223 15:43:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 224 15:43:48 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 225 15:43:48 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 226 15:43:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 227 15:43:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 228 15:43:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 229 15:43:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 01% 230 15:43:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 231 15:43:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 232 15:43:48 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 233 15:43:49 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 234 15:43:49 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 235 15:43:49 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 236 15:43:49 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 237 15:43:49 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 011% 238 15:43:49 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 239 15:43:49 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 240 15:43:49 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 241 15:43:50 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 242 15:43:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 243 15:43:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 244 15:43:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 245 15:43:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 011% 246 15:43:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 247 15:43:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 248 15:43:50 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 249 15:43:50 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 250 15:43:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 251 15:43:50 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 252 15:43:50 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 253 15:43:50 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 01101% 254 15:43:50 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 255 15:43:50 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 256 15:43:50 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 257 15:43:52 SQL Prepare: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=:1 AND yblb00=ybzxlb 258 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 259 15:43:52 SQL Execute: ORACLE - select yblb00,ybmc00,ybzxlb,sfjsdw from ic_ybbrlb where FBBH00=? AND yblb00=ybzxlb 260 15:43:52 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 261 15:43:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 262 15:43:52 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 263 15:43:52 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 264 15:43:52 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 01101% 265 15:43:52 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 266 15:43:52 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 267 15:43:52 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 268 15:43:55 SQL Prepare: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=:1 AND YBZXLB=:2 and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=:3 and rtrim(ltrim(bh0000)) like :4 ) and sfybxm like :5 and TZBZ00 like :6 order by YYXMBH 269 15:43:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 270 15:43:55 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 271 15:43:55 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 272 15:43:55 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 01101% 273 15:43:55 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 274 15:43:55 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = % 275 15:43:55 SQL Execute: ORACLE - SELECT FBBH00,SFXMID,YBZXLB,YYDJXH AS YYDJ00,YYDJMC,YYXMMC,YBXMBH,YBXMMC,ZFBL00,ZFJE00,YBZYFP,YBMZFP,ZYFPXM,MZFPXM, SFYP00,SFYBXM,YBLB00, DECODE(SFYBXM,'Y','医保项目','N','非医保项目')SFXM00,ybbrlb, DECODE(YBLB00,'0','甲类','1','乙类','2','自费','3','自费(补充)')YBBL00,YYXMBH,JMBL00,JMJE00, SF_GETXMJE('N',SFXMID,YYDJXH,0,'0','0') AS XMJE00,SFSX00,BH0000,BZ0000,TZBZ00 FROM VW_BM_YBSFDYXMMCFP WHERE FBBH00=? AND YBZXLB=? and sfxmid in (select sfxmid from bm_yysfxm where bmgzid=? and rtrim(ltrim(bh0000)) like ? ) and sfybxm like ? and TZBZ00 like ? order by YYXMBH 276 15:44:02 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=353009 277 15:44:02 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=353009 278 15:44:02 SQL Data In: ORACLE - Rows affected = 1 279 15:44:02 SQL Prepare: ORACLE - Commit 280 15:44:02 SQL Execute: ORACLE - Commit 281 15:44:02 SQL Data In: ORACLE - Rows affected = 0 282 15:44:02 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 283 15:44:02 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 284 15:44:02 SQL Data In: ORACLE - Rows affected = 0 285 15:44:02 SQL Prepare: ORACLE - Commit 286 15:44:02 SQL Execute: ORACLE - Commit 287 15:44:02 SQL Data In: ORACLE - Rows affected = 0 288 15:44:03 Log started for: 后台维护系统 289 15:44:14 SQL Prepare: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,5,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'110400' and BH0000<='110499' 290 15:44:14 SQL Execute: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,5,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'110400' and BH0000<='110499' 291 15:44:17 SQL Prepare: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'1100' and BH0000<='1199' 292 15:44:17 SQL Execute: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'1100' and BH0000<='1199' 293 15:44:18 SQL Prepare: ORACLE - Select SF_YJ_GETPYSM('新科室1108') PYSM00,SF_YJ_GETWBSM('新科室1108') WBSM00 from Dual 294 15:44:18 SQL Execute: ORACLE - Select SF_YJ_GETPYSM('新科室1108') PYSM00,SF_YJ_GETWBSM('新科室1108') WBSM00 from Dual 295 15:44:19 SQL Prepare: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'1100' and BH0000<='1199' 296 15:44:19 SQL Execute: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'1100' and BH0000<='1199' 297 15:44:20 SQL Prepare: ORACLE - insert into BM_BMBM00 (BMBH00, BH0000, FLAG00, BMMC00, PYSM00, WBSM00, BMXZ00, FYBZ00, SYCW00, YJXX00, CKXX00, JZXX00, CZBZ00, KSDH00) values (SQ_BM_BMBM00_BMBH00.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) 298 15:44:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1108 299 15:44:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 300 15:44:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 新科室1108 301 15:44:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = xks1108 302 15:44:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = utp1108 303 15:44:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 304 15:44:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 305 15:44:20 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 306 15:44:20 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 307 15:44:20 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000 308 15:44:20 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 309 15:44:20 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 310 15:44:20 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 311 15:44:20 SQL Execute: ORACLE - insert into BM_BMBM00 (BMBH00, BH0000, FLAG00, BMMC00, PYSM00, WBSM00, BMXZ00, FYBZ00, SYCW00, YJXX00, CKXX00, JZXX00, CZBZ00, KSDH00) values (SQ_BM_BMBM00_BMBH00.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 312 15:44:20 SQL Error: ORACLE - ORA-01400: 无法将 NULL 插入 ("SD_HOSPITAL"."BM_BMBM00"."YYID00") 313 15:46:01 SQL Prepare: ORACLE - ROLLBACK WORK 314 15:46:01 SQL Execute: ORACLE - ROLLBACK WORK 315 15:46:03 SQL Data In: ORACLE - Rows affected = 0 316 15:46:33 Log started for: 后台维护系统 317 15:46:33 SQL Prepare: ORACLE - Select SYSDATE from Dual 318 15:46:33 SQL Execute: ORACLE - Select SYSDATE from Dual 319 15:46:33 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 320 15:46:33 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 321 15:46:33 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 322 15:46:33 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='6' 323 15:46:33 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 324 15:46:33 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 325 15:46:33 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 326 15:46:33 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 327 15:46:33 SQL Prepare: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='6' 328 15:46:33 SQL Execute: ORACLE - Select DLFS00 from XT_YYXT00 where XTDM00='6' 329 15:46:35 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='6' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 330 15:46:35 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('8') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='6' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 331 15:46:36 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 332 15:46:36 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9999'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '6' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9999')) 333 15:46:36 SQL Prepare: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 334 15:46:36 SQL Execute: ORACLE - Select * from BM_YGBM00 where UPPER(XKH000)='9999' and CZBZ00='1' 335 15:46:36 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 336 15:46:36 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 337 15:46:36 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 338 15:46:36 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 339 15:46:36 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 340 15:46:36 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='10.140.151.77' 341 15:46:36 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 342 15:46:36 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 343 15:46:36 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,17,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 344 15:46:36 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 15 and FLAG00 like '%' order by decode(CKBH00,17,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 345 15:46:36 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 346 15:46:36 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 347 15:46:36 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 348 15:46:36 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 349 15:46:36 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(159364,369,'STARTCHUGE','6',nvl('17056',' '),'',15) 350 15:46:36 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(159364,369,'STARTCHUGE','6',nvl('17056',' '),'',15) 351 15:46:36 SQL Data In: ORACLE - Rows affected = 1 352 15:46:36 SQL Prepare: ORACLE - Commit 353 15:46:36 SQL Execute: ORACLE - Commit 354 15:46:36 SQL Data In: ORACLE - Rows affected = 0 355 15:46:36 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090506' 356 15:46:36 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='6') and YXQ000>='20090506' 357 15:46:36 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 358 15:46:36 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYY.MM.DD') OraSysDate FROM DUAL 359 15:46:36 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 360 15:46:36 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 361 15:46:36 SQL Prepare: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='6' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 362 15:46:36 SQL Execute: ORACLE - select MKDM00,MKNBMC from XT_XTMK00 where XTDM00='6' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 363 15:46:36 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 364 15:46:36 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '6$%' and A.XTDM00='6' and trim(A.MKDM00)='6$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND ((369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='6' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) ORDER BY B.F_TEMPTYPE,A.MKDM00 365 15:46:36 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 366 15:46:36 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 369= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='+' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=369)))) 367 15:46:38 SQL Prepare: ORACLE - select * from XT_BMXZ00 368 15:46:38 SQL Execute: ORACLE - select * from XT_BMXZ00 369 15:46:38 SQL Prepare: ORACLE - Select * from BM_BMBM00 order by BH0000 370 15:46:38 SQL Execute: ORACLE - Select * from BM_BMBM00 order by BH0000 371 15:46:42 SQL Prepare: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'0100' and BH0000<='0199' 372 15:46:42 SQL Execute: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'0100' and BH0000<='0199' 373 15:46:42 SQL Prepare: ORACLE - Select SF_YJ_GETPYSM('新科室0122') PYSM00,SF_YJ_GETWBSM('新科室0122') WBSM00 from Dual 374 15:46:42 SQL Execute: ORACLE - Select SF_YJ_GETPYSM('新科室0122') PYSM00,SF_YJ_GETWBSM('新科室0122') WBSM00 from Dual 375 15:46:44 SQL Prepare: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'0100' and BH0000<='0199' 376 15:46:44 SQL Execute: ORACLE - Select LPAD(TO_CHAR(MAX(TO_NUMBER((SUBSTR(BH0000,3,2))))+1),2,0) NEXT from BM_BMBM00 where BH0000>'0100' and BH0000<='0199' 377 15:46:44 SQL Prepare: ORACLE - insert into BM_BMBM00 (BMBH00, BH0000, FLAG00, BMMC00, PYSM00, WBSM00, BMXZ00, FYBZ00, SYCW00, YJXX00, CKXX00, JZXX00, CZBZ00, KSDH00) values (SQ_BM_BMBM00_BMBH00.NEXTVAL, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) 378 15:46:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0122 379 15:46:44 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 380 15:46:44 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 新科室0122 381 15:46:44 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = xks0122 382 15:46:44 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = utp0122 383 15:46:44 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 384 15:46:44 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 385 15:46:44 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 386 15:46:44 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 387 15:46:44 SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 100.000000 388 15:46:44 SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 389 15:46:44 SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 390 15:46:44 SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 391 15:46:44 SQL Execute: ORACLE - insert into BM_BMBM00 (BMBH00, BH0000, FLAG00, BMMC00, PYSM00, WBSM00, BMXZ00, FYBZ00, SYCW00, YJXX00, CKXX00, JZXX00, CZBZ00, KSDH00) values (SQ_BM_BMBM00_BMBH00.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) 392 15:46:44 SQL Error: ORACLE - ORA-01400: 无法将 NULL 插入 ("SD_HOSPITAL"."BM_BMBM00"."YYID00")