1 08:43:17 Log started for: 检验信息系统 2 08:43:17 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.27.25.201','J',trim(PROGRAM)||'+'||'检 验 管 理 系 统',SID,serial# ,'20110601','08:43:16','scott@fanjj:27E53EF0CEDDEE35A03B788AC604E013' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 08:43:17 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.27.25.201','J',trim(PROGRAM)||'+'||'检 验 管 理 系 统',SID,serial# ,'20110601','08:43:16','scott@fanjj:27E53EF0CEDDEE35A03B788AC604E013' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 08:43:17 SQL Data In: ORACLE - Rows affected = 1 5 08:43:17 SQL Prepare: ORACLE - Commit 6 08:43:17 SQL Execute: ORACLE - Commit 7 08:43:17 SQL Data In: ORACLE - Rows affected = 0 8 08:43:17 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 08:43:17 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 08:43:17 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='224465' 11 08:43:17 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='224465' 12 08:43:17 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='FANJJ' and CZBZ00 in ('1') 13 08:43:17 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='FANJJ' and CZBZ00 in ('1') 14 08:43:17 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.27.25.201','J',trim(PROGRAM)||'+'||'检 验 管 理 系 统',SID,serial# ,'20110601','08:43:16','sd_hospital@fanjj:90513A8E90A273CF1917FE55517DE17E' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 15 08:43:17 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '172.27.25.201','J',trim(PROGRAM)||'+'||'检 验 管 理 系 统',SID,serial# ,'20110601','08:43:16','sd_hospital@fanjj:90513A8E90A273CF1917FE55517DE17E' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 16 08:43:17 SQL Data In: ORACLE - Rows affected = 1 17 08:43:17 SQL Prepare: ORACLE - Commit 18 08:43:17 SQL Execute: ORACLE - Commit 19 08:43:17 SQL Data In: ORACLE - Rows affected = 0 20 08:43:17 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 21 08:43:17 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='J' 22 08:43:17 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='FANJJ' and CZBZ00 in ('1') 23 08:43:17 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='FANJJ' and CZBZ00 in ('1') 24 08:43:17 SQL Prepare: ORACLE - Select SYSDATE from Dual 25 08:43:17 SQL Execute: ORACLE - Select SYSDATE from Dual 26 08:43:17 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 08:43:17 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 28 08:43:17 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 29 08:43:17 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 30 08:43:17 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 31 08:43:17 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='J' 32 08:43:17 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 33 08:43:17 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 34 08:43:17 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 35 08:43:17 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 36 08:43:17 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) order by b.PLXH00,a.BH0000 37 08:43:17 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('0','1','2','3','4','5','6','7','8','9') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) order by b.PLXH00,a.BH0000 38 08:43:17 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where 'fanjj'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ') 39 08:43:17 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where 'fanjj'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= 'J' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='J' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='FANJJ') 40 08:43:17 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=588 41 08:43:17 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=588 42 08:43:17 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 08:43:17 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 44 08:43:17 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 45 08:43:17 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 46 08:43:17 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 08:43:17 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 48 08:43:17 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 08:43:17 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 50 08:43:17 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 51 08:43:17 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 52 08:43:17 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(983882,588,'PC-2520','J',nvl('1839352',' '),'172.27.25.201#121:55807@PrjLIS_LIS.exe+检 验 管 理 系 统',40) 53 08:43:17 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(983882,588,'PC-2520','J',nvl('1839352',' '),'172.27.25.201#121:55807@PrjLIS_LIS.exe+检 验 管 理 系 统',40) 54 08:43:17 SQL Data In: ORACLE - Rows affected = 1 55 08:43:17 SQL Prepare: ORACLE - Commit 56 08:43:17 SQL Execute: ORACLE - Commit 57 08:43:18 SQL Data In: ORACLE - Rows affected = 0 58 08:43:18 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 40 59 08:43:18 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 40 60 08:43:18 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '224465' 61 08:43:18 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '224465' 62 08:43:18 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 63 08:43:18 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 64 08:43:18 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='172.27.25.201' 65 08:43:18 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='172.27.25.201' 66 08:43:18 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 67 08:43:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 68 08:43:18 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 40 and FLAG00 like '%' order by decode(CKBH00,99,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 69 08:43:18 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 40 and FLAG00 like '%' order by decode(CKBH00,99,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 70 08:43:18 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('224465') 71 08:43:18 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('224465') 72 08:43:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 73 08:43:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 74 08:43:18 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='588' and name00='SYSTEMSKIN' 75 08:43:18 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='588' and name00='SYSTEMSKIN' 76 08:43:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 77 08:43:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 78 08:43:18 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='J') and YXQ000>='20110601' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',40,' )>0 ) 79 08:43:18 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='J') and YXQ000>='20110601' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',40,' )>0 ) 80 08:43:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 81 08:43:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 82 08:43:18 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 83 08:43:18 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 84 08:43:18 SQL Prepare: ORACLE - select sysdate from dual 85 08:43:18 SQL Execute: ORACLE - select sysdate from dual 86 08:43:18 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 588 87 08:43:18 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM','ZYTXMPRT','MZTXMPRT','JYBGDPRT','BB000PRT') and YGBH00 = 588 88 08:43:18 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 89 08:43:18 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_JY_%' AND STATUS<>'VALID' 90 08:43:18 SQL Prepare: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 40 91 08:43:18 SQL Execute: ORACLE - select * from vw_jy_tjks00 where BMBH00 = 40 92 08:43:18 SQL Prepare: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 93 08:43:18 SQL Execute: ORACLE - select QZ0000 from JY_SGCJZD where dqzy00='Y' 94 08:43:18 SQL Prepare: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 95 08:43:18 SQL Execute: ORACLE - SELECT * FROM XT_YYXT00 WHERE XTDM00 = 'J' and (XTBB00='5.0版' or SUBSTR(XTBB00,1,5)='05.00') 96 08:43:18 SQL Prepare: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 97 08:43:18 SQL Execute: ORACLE - select * from xt_xtcs00 where NAME00 like 'JY_%' or NAME00 = 'YS_ZHXMXZ' 98 08:43:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='J'))) 99 08:43:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='J' and (( 588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='J'))) 100 08:43:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||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 BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 101 08:43:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'J$%' and A.XTDM00='J' and trim(A.MKDM00)='J$'||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 BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 102 08:43:18 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 ((588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='0 '))) 103 08:43:18 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 ((588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='0 '))) 104 08:43:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 105 08:43:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 106 08:43:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='+ '))) 107 08:43:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 588= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=588 and XTDM00='+ '))) 108 08:43:22 SQL Prepare: ORACLE - select MC0000,ID0000 from JY_DYFZB0 where LB0000='2' ORDER BY MC0000 109 08:43:22 SQL Execute: ORACLE - select MC0000,ID0000 from JY_DYFZB0 where LB0000='2' ORDER BY MC0000 110 08:43:22 SQL Prepare: ORACLE - select bbid00,rownum||'|'||bbmc00 bbmc00 from BM_BBZD00 order by bbid00 111 08:43:22 SQL Execute: ORACLE - select bbid00,rownum||'|'||bbmc00 bbmc00 from BM_BBZD00 order by bbid00 112 08:43:22 SQL Prepare: ORACLE - select ZYZBMC,ZYZBID from BM_JYZYZB where SYBZ00='Y' 113 08:43:22 SQL Execute: ORACLE - select ZYZBMC,ZYZBID from BM_JYZYZB where SYBZ00='Y' 114 08:43:22 SQL Prepare: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='588' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1'))ORDER BY YQDH00 115 08:43:22 SQL Execute: ORACLE - select YQDH00||'|'||YQJC00,YQDH00 from JY_JYYQZD where YXBZ00='Y' and YQDH00 IN (SELECT YQDH00 FROM JY_YGQXZD WHERE YGBH00='588' AND QXID00=(SELECT QXID00 FROM JY_QXZD00 WHERE QXGNDH='XSYQ' and ROWNUM='1'))ORDER BY YQDH00 116 08:43:22 SQL Prepare: ORACLE - select VALUE0,DM0000 from XT_ZD0000 where YXBZ00='1' AND ZDBM00='BBZT00' ORDER BY DM0000 117 08:43:22 SQL Execute: ORACLE - select VALUE0,DM0000 from XT_ZD0000 where YXBZ00='1' AND ZDBM00='BBZT00' ORDER BY DM0000 118 08:43:22 SQL Prepare: ORACLE - select ZYZBID from bm_jyzyzb where zyzbid=(select ZYZBID from jy_jyyqzd WHERE yqdh00='A8') 119 08:43:22 SQL Execute: ORACLE - select ZYZBID from bm_jyzyzb where zyzbid=(select ZYZBID from jy_jyyqzd WHERE yqdh00='A8') 120 08:43:22 SQL Prepare: ORACLE - select BBID00 from JY_JYYQZD where YQDH00='A8' 121 08:43:22 SQL Execute: ORACLE - select BBID00 from JY_JYYQZD where YQDH00='A8' 122 08:43:22 SQL Prepare: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 123 08:43:22 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 124 08:43:22 SQL Prepare: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 125 08:43:22 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 126 08:43:22 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 127 08:43:22 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 128 08:43:22 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 129 08:43:22 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 130 08:43:22 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 08:43:22 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 132 08:43:22 SQL Prepare: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 133 08:43:22 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 134 08:43:22 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 135 08:43:22 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 136 08:43:22 SQL Prepare: ORACLE - select * from JY_JYYQZD where YQMC00='BICLIAISON' and YQDH00 = 'A8' 137 08:43:22 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00='BICLIAISON' and YQDH00 = 'A8' 138 08:43:23 SQL Prepare: ORACLE - SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20110601' 139 08:43:23 SQL Execute: ORACLE - SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='' AND PYRQ00='20110601' 140 08:43:23 SQL Prepare: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 141 08:43:23 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 142 08:43:23 SQL Prepare: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 143 08:43:23 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 144 08:43:23 SQL Prepare: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 145 08:43:23 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 146 08:43:23 SQL Prepare: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 147 08:43:23 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 148 08:43:23 SQL Prepare: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 149 08:43:23 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 150 08:43:23 SQL Prepare: ORACLE - select rownum,JG.* from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ORDER BY XH0000) JG 151 08:43:23 SQL Execute: ORACLE - select rownum,JG.* from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ORDER BY XH0000) JG 152 08:43:23 SQL Prepare: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,A.DW0000,B.XJKSID FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT Exists (SELECT 'Y' from JY_XJBGJG WHERE KSSID0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0000 153 08:43:23 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,A.DW0000,B.XJKSID FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT Exists (SELECT 'Y' from JY_XJBGJG WHERE KSSID0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0000 154 08:43:23 SQL Prepare: ORACLE - select jgzt00 from jy_yw0000 where ybh000='' and pyrq00='' 155 08:43:23 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='' and pyrq00='' 156 08:43:23 SQL Prepare: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='A8' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 157 08:43:23 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='A8' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 158 08:43:23 SQL Prepare: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='A8' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='A8') 159 08:43:23 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='A8' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='A8') 160 08:43:23 SQL Prepare: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='A8' 161 08:43:23 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='A8' 162 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 163 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 164 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 165 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 166 08:43:23 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 167 08:43:23 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 168 08:43:23 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 169 08:43:23 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 170 08:43:23 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 171 08:43:23 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 172 08:43:23 SQL Prepare: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 173 08:43:23 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 174 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 175 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 176 08:43:23 SQL Prepare: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='23' 177 08:43:23 SQL Execute: ORACLE - select BBBZ00,XH0000 from JY_BBBZZD where BBID00='23' 178 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 179 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 180 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 181 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 182 08:43:23 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 183 08:43:23 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'A8%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 184 08:43:23 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 185 08:43:23 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 186 08:43:23 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 187 08:43:23 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 188 08:43:23 SQL Prepare: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 189 08:43:23 SQL Execute: ORACLE - SELECT BBID00 from jy_JYYQZD where YQDH00='A8' 190 08:43:23 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 191 08:43:23 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'A8' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 192 08:43:25 SQL Prepare: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 193 08:43:25 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XTZY00 LIKE 'F%' 194 08:43:25 SQL Prepare: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 195 08:43:25 SQL Execute: ORACLE - select ZWMC00,BGXMID from JY_BGXMZD where XMSM00='尿液分析(CL)' 196 08:43:25 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 197 08:43:25 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 198 08:43:25 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 199 08:43:25 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 200 08:43:25 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 201 08:43:25 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 202 08:43:25 SQL Prepare: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 203 08:43:25 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 204 08:43:25 SQL Prepare: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 205 08:43:25 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 206 08:43:25 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 207 08:43:25 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 208 08:43:25 SQL Prepare: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = :1 and a.YBH000 = :2 UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = :3 and a.YBH000 = :4 ) WHERE JYYWID > 0 order by DYSX00 209 08:43:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 210 08:43:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 211 08:43:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 212 08:43:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 213 08:43:25 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 214 08:43:25 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 215 08:43:25 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 216 08:43:25 SQL Prepare: ORACLE - select * from JY_JYYQZD where YQMC00='BICLIAISON' and YQDH00 = 'CE' 217 08:43:25 SQL Execute: ORACLE - select * from JY_JYYQZD where YQMC00='BICLIAISON' and YQDH00 = 'CE' 218 08:43:25 SQL Prepare: ORACLE - SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='CE0010' AND PYRQ00='20110601' 219 08:43:25 SQL Execute: ORACLE - SELECT DISTINCT A.JYYWID,A.YBH000,A.PYRQ00,A.XJID00,A.XJMS00,B.ZWMC00,A.XJJG00,A.BGDH00,A.XJKSID FROM JY_XJBGJG A,JY_XJZD00 B WHERE A.XJID00=B.XJID00 AND YBH000='CE0010' AND PYRQ00='20110601' 220 08:43:25 SQL Prepare: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 221 08:43:25 SQL Execute: ORACLE - select * from JY_XJJGPY where PYRQ00='' and YBH000='' 222 08:43:25 SQL Prepare: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 223 08:43:25 SQL Execute: ORACLE - SELECT JSID00 FROM JY_XJJSDY WHERE XJID00='' 224 08:43:25 SQL Prepare: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 225 08:43:25 SQL Execute: ORACLE - SELECT JSMC00 FROM JY_JSZD00 WHERE JSID00='0' 226 08:43:26 SQL Prepare: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 227 08:43:26 SQL Execute: ORACLE - SELECT ZWMC00 FROM JY_XJZD00 WHERE XJID00='' 228 08:43:26 SQL Prepare: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 229 08:43:26 SQL Execute: ORACLE - select FZMC00 FROM JY_XJKSFZ WHERE XJKSID='' 230 08:43:26 SQL Prepare: ORACLE - select rownum,JG.* from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ORDER BY XH0000) JG 231 08:43:26 SQL Execute: ORACLE - select rownum,JG.* from (select B.ZWMC00,B.MCSX00,a.YMJG00,a.YMJGKB,a.YMSM00,a.JGBZ00,a.bgjgid,A.KSSID0,A.XJJG00,A.XJKSID from JY_XJBGJG a,JY_KSSZD0 B where B.KSSID0=A.KSSID0 AND XJID00='' AND YBH000='' AND PYRQ00='' ORDER BY XH0000) JG 232 08:43:26 SQL Prepare: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,A.DW0000,B.XJKSID FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT Exists (SELECT 'Y' from JY_XJBGJG WHERE KSSID0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0000 233 08:43:26 SQL Execute: ORACLE - SELECT 'N' XY0000,A.KSSID0,A.ZWMC00,A.YWMC00,A.MCSX00,A.XH0000,A.DW0000,B.XJKSID FROM JY_KSSZD0 A,JY_KSSFZ0 B where A.kssid0=B.KSSID0 AND NOT Exists (SELECT 'Y' from JY_XJBGJG WHERE KSSID0=B.KSSID0 and XJID00='' AND YBH000='' AND PYRQ00='') AND B.XJKSID='' ORDER BY XY0000 DESC,XH0000 234 08:43:26 SQL Prepare: ORACLE - select jgzt00 from jy_yw0000 where ybh000='CE0010' and pyrq00='20110601' 235 08:43:26 SQL Execute: ORACLE - select jgzt00 from jy_yw0000 where ybh000='CE0010' and pyrq00='20110601' 236 08:43:26 SQL Prepare: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CE' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 237 08:43:26 SQL Execute: ORACLE - select LPAD(NVL(MAX(TO_NUMBER(SUBSTR(YBH000,3,4)))+1,1),4,'0') from JY_YW0000 where YQDH00='CE' and PYRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') 238 08:43:26 SQL Prepare: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CE' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CE') 239 08:43:26 SQL Execute: ORACLE - select distinct zlxmid from jy_zlbgdy where yqdh00='CE' or YQDH00=(SELECT NVL(FROMYQ,'11') FROM JY_JYYQZD WHERE YQDH00='CE') 240 08:43:26 SQL Prepare: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CE' 241 08:43:26 SQL Execute: ORACLE - select bbid00 from JY_JYYQZD where yqdh00='CE' 242 08:43:26 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 243 08:43:26 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 244 08:43:26 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 245 08:43:26 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 246 08:43:26 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 247 08:43:26 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 248 08:43:26 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 249 08:43:26 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 250 08:43:26 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 251 08:43:26 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 252 08:43:26 SQL Prepare: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 253 08:43:26 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 254 08:43:26 SQL Prepare: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 255 08:43:26 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 256 08:43:26 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 257 08:43:26 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 258 08:43:26 SQL Prepare: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = :1 and a.YBH000 = :2 UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = :3 and a.YBH000 = :4 ) WHERE JYYWID > 0 order by DYSX00 259 08:43:26 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 260 08:43:26 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 261 08:43:26 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 262 08:43:26 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 263 08:43:26 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 264 08:43:26 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 265 08:43:26 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 266 08:43:35 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 267 08:43:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 268 08:43:35 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 269 08:43:35 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 270 08:43:35 SQL Prepare: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 271 08:43:35 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0100018587 272 08:43:35 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 273 08:43:35 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 274 08:43:35 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0019 275 08:43:35 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 276 08:43:35 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 277 08:43:35 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 588 278 08:43:35 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 279 08:43:35 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 280 08:43:35 SQL Prepare: ORACLE - COMMIT 281 08:43:35 SQL Execute: ORACLE - COMMIT 282 08:43:35 SQL Data In: ORACLE - Rows affected = 0 283 08:43:35 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 284 08:43:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 285 08:43:35 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 286 08:43:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JMXZ' 287 08:43:35 SQL Prepare: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 288 08:43:35 SQL Execute: ORACLE - select ROWNUM RECNO,YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from (select distinct YBH000,PYRQ00,BRXM00,ZYHGHH,MZZYBZ,yxbz00,SECTOR,CUPNUM from VW_JYYW_JYJG00_TEMP A where PYRQ00='20110601' and YBH000 LIKE 'CE%' and JGZT00||'A' in ('4A','5A') ) order by YBH000 289 08:43:35 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 290 08:43:35 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 291 08:43:35 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 292 08:43:35 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 293 08:43:35 SQL Prepare: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 294 08:43:35 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0010' and PYRQ00='20110601' order by jyywid desc 295 08:43:35 SQL Prepare: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 296 08:43:35 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 297 08:43:35 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 298 08:43:35 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0010' and PYRQ00 = '20110601') 299 08:43:35 SQL Prepare: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = :1 and a.YBH000 = :2 UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = :3 and a.YBH000 = :4 ) WHERE JYYWID > 0 order by DYSX00 300 08:43:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 301 08:43:35 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 302 08:43:35 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 303 08:43:35 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0010 304 08:43:35 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 305 08:43:35 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 306 08:43:35 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 307 08:43:36 SQL Prepare: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 308 08:43:36 SQL Data In: ORACLE - Param = 1, Name = P_PYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 309 08:43:36 SQL Data In: ORACLE - Param = 2, Name = P_YBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0019 310 08:43:36 SQL Execute: ORACLE - BEGIN "SP_JY_INSERT_CALITEM" (P_PYRQ00 => :P_PYRQ00,P_YBH000 => :P_YBH000); END; 311 08:43:36 SQL Prepare: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0019' and PYRQ00='20110601' order by jyywid desc 312 08:43:36 SQL Execute: ORACLE - select * from vw_JY_YW0000 where YBH000='CE0019' and PYRQ00='20110601' order by jyywid desc 313 08:43:36 SQL Prepare: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 314 08:43:36 SQL Execute: ORACLE - select BBID00 from jy_JYYQZD where YQDH00='CE' 315 08:43:36 SQL Prepare: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0019' and PYRQ00 = '20110601') 316 08:43:36 SQL Execute: ORACLE - select zlxmjc from bm_zlzd00 where zlxmid in (select zlxmid from jy_ywmx00 where YBH000 = 'CE0019' and PYRQ00 = '20110601') 317 08:43:36 SQL Prepare: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = :1 and a.YBH000 = :2 UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = :3 and a.YBH000 = :4 ) WHERE JYYWID > 0 order by DYSX00 318 08:43:36 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 319 08:43:36 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0019 320 08:43:36 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 321 08:43:36 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0019 322 08:43:36 SQL Execute: ORACLE - select * from (SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00 a WHERE a.PYRQ00 = ? and a.YBH000 = ? UNION SELECT a.JGID00,a.JYYWID,a.ZLXMID,a.DYSX00,a.BGXMID,a.BGXMMC,a.JYJG00,a.JGLX00,a.JGDW00,a.zwmc00, a.YSJYJG,a.JGZCBZ,a.YQDH00,a.YBH000,a.PYRQ00,a.CKZNL0,a.CKZXB0,a.CKZBB0,a.CKZBL0,a.JD0000,a.XTZY00,a.SECTOR,a.CUPNUM,a.CKXX00,a.CKSX00,a.CKFW00,a.YQJCRQ,a.OD0000,a.BGRQ00,a.BGSJ00,a.jjzsx0,a.jjzxx0,a.SFJM00,a.bzbm00 from VW_JY_JYJG00_TEMP a WHERE a.PYRQ00 = ? and a.YBH000 = ? ) WHERE JYYWID > 0 order by DYSX00 323 08:43:36 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 324 08:43:36 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'JGXG' 325 08:43:36 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 326 08:43:36 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 327 08:43:36 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 328 08:43:36 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 329 08:43:36 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0100018587 330 08:43:36 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 331 08:43:36 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 332 08:43:36 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0020 333 08:43:36 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 334 08:43:36 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 335 08:43:36 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 588 336 08:43:36 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 337 08:43:36 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 338 08:43:36 SQL Error: ORACLE - ORA-20005: 标本已排样！*样本号：CE0019 ORA-06512: 在"SD_HOSPITAL.SP_JY_JYBBPY", line 265 ORA-06512: 在line 1 339 08:43:36 SQL Error: ORACLE - Unmapped SQL Error Code: 20005 340 08:43:43 SQL Prepare: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 341 08:43:43 SQL Execute: ORACLE - select * from VW_JY_YGQXZD where YGBH00 = '588' and YQDH00 = 'CE' AND QXLX00 = 'JGCL' and QXGNDH = 'BBPY' 342 08:43:43 SQL Prepare: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 343 08:43:43 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 344 08:43:43 SQL Data In: ORACLE - Param = 1, Name = PTXM000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 0100018524 345 08:43:43 SQL Data In: ORACLE - Param = 2, Name = PJYYWID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 346 08:43:43 SQL Data In: ORACLE - Param = 3, Name = PPYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110601 347 08:43:43 SQL Data In: ORACLE - Param = 4, Name = PYBH000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = CE0020 348 08:43:43 SQL Data In: ORACLE - Param = 5, Name = PJZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 349 08:43:43 SQL Data In: ORACLE - Param = 6, Name = PSGCJQZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 01 350 08:43:43 SQL Data In: ORACLE - Param = 7, Name = PPYRID0, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 588 351 08:43:43 SQL Data In: ORACLE - Param = 8, Name = PBBQSBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 352 08:43:43 SQL Execute: ORACLE - BEGIN "SP_JY_JYBBPY" (PTXM000 => :PTXM000,PJYYWID => :PJYYWID,PPYRQ00 => :PPYRQ00,PYBH000 => :PYBH000,PJZBZ00 => :PJZBZ00,PSGCJQZ => :PSGCJQZ,PPYRID0 => :PPYRID0,PBBQSBZ => :PBBQSBZ); END; 353 08:43:43 SQL Error: ORACLE - ORA-03106: 致命的双工通信协议错误 354 08:43:43 SQL Error: ORACLE - Unmapped SQL Error Code: 3106