1       08:36:30  Log started for: 住院医生工作站系统
2       08:36:30  SQL Prepare: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','70','1938' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual

3       08:36:30  SQL Execute: ORACLE -  Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','70','1938' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual

4       08:36:30  SQL Data In: ORACLE - Rows affected = 1
5       08:36:30  SQL Prepare: ORACLE - Commit

6       08:36:30  SQL Execute: ORACLE - Commit

7       08:36:30  SQL Data In: ORACLE - Rows affected = 0
8       08:36:30  SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

9       08:36:30  SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

10      08:36:30  SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

11      08:36:30  SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137'

12      08:36:30  SQL Prepare: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

13      08:36:30  SQL Execute: ORACLE -  select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

14      08:36:30  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

15      08:36:30  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

16      08:36:30  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','630','1112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual

17      08:36:30  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','630','1112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual

18      08:36:30  SQL Data In: ORACLE - Rows affected = 1
19      08:36:30  SQL Prepare: ORACLE - Commit

20      08:36:30  SQL Execute: ORACLE - Commit

21      08:36:30  SQL Data In: ORACLE - Rows affected = 0
22      08:36:30  SQL Prepare: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

23      08:36:30  SQL Execute: ORACLE -  select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z'

24      08:36:30  SQL Prepare: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

25      08:36:30  SQL Execute: ORACLE -  select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 

26      08:36:30  SQL Prepare: ORACLE - Select SYSDATE from Dual

27      08:36:30  SQL Execute: ORACLE - Select SYSDATE from Dual

28      08:36:30  SQL Prepare: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

29      08:36:30  SQL Execute: ORACLE -  Select INSTANCE_NAME,HOST_NAME from V$INSTANCE

30      08:36:30  SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

31      08:36:30  SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1

32      08:36:30  SQL Prepare: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

33      08:36:30  SQL Execute: ORACLE -  Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z'

34      08:36:30  SQL Prepare: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

35      08:36:30  SQL Execute: ORACLE -  Select * from XT_YYXX00  where flag00 in ('0','1') order by flag00 desc 

36      08:36:30  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

37      08:36:30  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

38      08:36:30  SQL Prepare: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('0',',','1',',','8')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

39      08:36:30  SQL Execute: ORACLE -  Select a.BMMC00,a.BMBH00 from BM_BMBM00 a  
,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b
 where a.FLAG00='1'  
 and a.BMBH00=b.BMBH00 
 and  a.BMXZ00 in ('0',',','1',',','8')
 and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z'
 and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 order by b.PLXH00,a.BH0000

40      08:36:35  SQL Prepare: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'Z' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

41      08:36:35  SQL Execute: ORACLE -  Select '0' as XTDM00 from dual where 
'343'='super' union 
 Select XTDM00 from XT_ZBQX00 where XTDM00=
'Z' and ZBDM00 in (
 Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 
 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343'))
 union 
 select XTDM00 from VW_XT_YHMKQX A where XTDM00='Z' and 
 YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 

42      08:36:35  SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

43      08:36:35  SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143

44      08:36:35  SQL Prepare: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

45      08:36:35  SQL Execute: ORACLE -  Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc

46      08:36:35  SQL Prepare: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

47      08:36:35  SQL Execute: ORACLE -  Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00'

48      08:36:35  SQL Prepare: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

49      08:36:35  SQL Execute: ORACLE -  Select userenv('SESSIONID') PROCESS from dual where rownum=1 

50      08:36:35  SQL Prepare: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

51      08:36:35  SQL Execute: ORACLE -  Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual

52      08:36:35  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'))

53      08:36:35  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'))

54      08:36:35  SQL Prepare: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3917263,1143,'wlzx-1','Z',nvl('226816653',' '),'192.168.14.220#630:1112@ZY_YS.exe+住院医生工作站系统',23)

55      08:36:35  SQL Execute: ORACLE -  Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) 
 Values(3917263,1143,'wlzx-1','Z',nvl('226816653',' '),'192.168.14.220#630:1112@ZY_YS.exe+住院医生工作站系统',23)

56      08:36:35  SQL Data In: ORACLE - Rows affected = 1
57      08:36:35  SQL Prepare: ORACLE - Commit

58      08:36:35  SQL Execute: ORACLE - Commit

59      08:36:35  SQL Data In: ORACLE - Rows affected = 0
60      08:36:35  SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 23

61      08:36:35  SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 23

62      08:36:35  SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

63      08:36:35  SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137'

64      08:36:35  SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

65      08:36:35  SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL

66      08:36:35  SQL Prepare: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.220'

67      08:36:35  SQL Execute: ORACLE -  Select JQBH00 from XT_SQIPDZ where IP0000='192.168.14.220'

68      08:36:35  SQL Prepare: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

69      08:36:35  SQL Execute: ORACLE -  select NAME00,VALUE0 from XT_XTCS00 where NAME00  in ('YF_CKJRZTXG','XT_SQIPDZ')

70      08:36:35  SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
23 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

71      08:36:35  SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00=
23 and FLAG00 like '%'
 order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00

72      08:36:35  SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

73      08:36:35  SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 

74      08:36:35  SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

75      08:36:35  SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'Z'||',')>0 

76      08:36:38  SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

77      08:36:38  SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN'

78      08:36:38  SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

79      08:36:38  SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ'

80      08:36:38  SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20131226'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',23,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z')

81      08:36:38  SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where  YXQ000>='20131226'
 and (JSKSBH is null or instr( ','||JSKSBH||',' , ',23,' )>0 )
 and XXXZ00='1' and (XTDM00='-1' or XTDM00='Z')

82      08:36:38  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

83      08:36:38  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN')

84      08:36:38  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

85      08:36:38  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG')

86      08:36:38  SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

87      08:36:38  SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1)

88      08:36:38  SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

89      08:36:38  SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL'

90      08:36:38  SQL Prepare: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','630','1112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

91      08:36:38  SQL Execute: ORACLE -  Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) 
 Select '192.168.14.220','Z','ZY_YS.exe'||'+'||'住院医生工作站系统','630','1112' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@ADO:' from dual

92      08:36:38  SQL Data In: ORACLE - Rows affected = 1
93      08:36:38  SQL Prepare: ORACLE - Commit

94      08:36:38  SQL Execute: ORACLE - Commit

95      08:36:38  SQL Data In: ORACLE - Rows affected = 0
96      08:36:38  SQL Prepare: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

97      08:36:38  SQL Execute: ORACLE - SELECT to_char(sid,'0000')  FROM V$SESSION where userenv('sessionid')=audsid 

98      08:36:38  SQL Prepare: ORACLE - begin 
 package_zhcx.set_var('0630'); 
 END;

99      08:36:38  SQL Execute: ORACLE - begin 
 package_zhcx.set_var('0630'); 
 END;

100     08:36:38  SQL Data In: ORACLE - Rows affected = 0
101     08:36:38  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

102     08:36:38  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a

103     08:36:38  SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

104     08:36:38  SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a

105     08:36:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='Z'))) 

106     08:36:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='Z' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='Z'))) 

107     08:36:38  SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||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

108     08:36:38  SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like 'Z$%' and A.XTDM00='Z' and trim(A.MKDM00)='Z$'||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

109     08:36:38  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

110     08:36:38  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 ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 

111     08:36:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

112     08:36:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 

113     08:36:38  SQL Prepare: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 

114     08:36:38  SQL Execute: ORACLE -  select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 
1143= 0) or (BZ0000<>'0'
 and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 

115     08:36:38  SQL Prepare: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

116     08:36:38  SQL Execute: ORACLE - select OBJECT_NAME from user_objects
 where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID'

117     08:36:38  SQL Prepare: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

118     08:36:38  SQL Execute: ORACLE - select Trigger_Name from all_triggers
 where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%'

119     08:36:38  SQL Prepare: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','XT_SFSYTYTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','ZS_JKXXDZ_NEW','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','ZS_CZWTZYZSFKCJ','ZS_WCCJSFSHRYY','ZS_SFYXXGXM','ZS_YTZLDZSFKYCX','ZS_YZWHJMMRYZLB','ZS_SFTSMRCYBR','ZS_SJWDSFKCJ','ZS_CJZDTZLJYZ','ZS_WLJBRZBSRZLXMID','ZS_YBBRFYTSJE','ZS_NBBRFYTSJE','ZS_KJXCYLSYZSZLSFBYXBJ','ZS_KJXCYLSYZSSFSYTSXZ','ZS_CRBDJSFQZSR','ZS_BAQHJGTS','ZS_SFKYYJSYKSSYP','ZS_ZYBAJKSFZNCSYSHBA','ZS_SFSYYZYTZGN','YS_MBWHSFXZDYF')

120     08:36:38  SQL Execute: ORACLE - select Value0,Name00 from xt_xtcs00 where name00 like '%YZSJFG%'  or name00 in ('zs_RunMode','XT_QDXXZHYE','ZS_YAPSSSFKYSC','BQ_NT5','BQ_RQDCDZ','ZS_YZDYGS','ZS_YZSFTD','ZS_BRQFSFYXLYZ','ZS_SSTHSFXG','ZS_FYYZSFSRZDHBQZY','BQ_SZYS_RYZDSFXS','ZS_MBSFTZ','ZS_SFXSBB','ZS_BLGSSFTZ','ZS_SFSYPASSXT','ZS_SFHISSJDR','ZS_YZDYLRSJ','SS_SFYFSZT','ZS_JYXMSRTZXX','ZS_BASYSGSRJBMC','ZS_YZWHJMXSBAH','ZS_CFJBKSSJB','ZS_FYYZXZJYXM','ZS_YZZJQRCDZ','ZS_SFGBADO','ZS_XZYSCZBLQX','ZS_CGBJJESFTS','ZS_YZYXBCYPBM','ZS_FTZYBCYPJJSH','ZS_SFZYYH','ZS_BRLLSFXSGDH','YS_ZFBRZFBLYBLB','ZS_BASYJBXXZDYID','ZS_BASYZDXXZDYID','ZS_BASYSSXXZDYID','ZS_YZWHSFZHJYXM','ZS_MZFFSFBT','ZS_SSSXSQDCSYZ','BQ_ZDLBSFXZXG','ZS_CFMBYYCLBZSFTS','ZS_ZYYZSFXYDJTS','ZS_BASYZJSSXX','ZS_SFSYXMLMSBL','ZS_XYZCYSFYXTZ','BQ_SFYXJC','ZS_ZYBASYJBXXZDYID','SFXSGRQKHSSSC','ZS_SFDYYZYSHS','ZS_SFXZBYS','ZS_ZYBASSQTXXZDYID','XK_SXSQBGDJ','XK_SFZDJYJG','XK_XKBMBH','ZS_RYZDSFSGSR','BQ_LRCZPSYCSPSDZ','BQ_HZYZXMST','ZS_YBSFXSWQZFYPBL','ZS_SFSYDTYYSCXT','XT_SFSYTYTYYSCXT','ZS_YZLRSFYXPZTZ','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB','ZS_SSSGLR','ZS_JKXXDZ_NEW','ZS_DKBLSFYCLC','ZS_BASYDYSFSYFR3SMDY','ZS_ZYBLDYSFMRMYDY','ZS_PACSTWBGWZ','ZS_PACSTXLLWZ','ZS_LISBGWZ','XT_LISCJDM','XT_PACSCJDM','SS_SQZDSFZDY','SS_ZXSWFYSSXM','SS_SSSQSFXSCW','ZS_RYZDWCRBZDSYQTXBGK','ZS_BASYSFTJBASSH','ZS_ZYBLA4DYHS','ZS_YZWHSFKZCJKS','ZS_SFSYBYLCLJ','ZS_AUTOSHOWYJYZ','ZS_SFKZYSRYWYP','ZS_YSWHYPBMQZ','ZS_LJJDSCFS','ZS_SERVERDIRCP','ZS_SFKYLRSRCS','BQ_TZYZSFXYHD','ZS_WXZBXYZSFTG','ZS_CQYZZJSSFTXYPSL','ZS_YZGLJMSJEXSFS','BQ_RQDZFBL_NOPRINT','BQ_YZLL_XSSJYE','ZY_RQDGSCS','ZY_RQDSFABRFYDY','ZS_SFZDGXLJ','ZS_YZWHJMSFXSYBWFSJE','ZS_YZCLLBSFSYZDY','ZS_CZWTZYZSFKCJ','ZS_WCCJSFSHRYY','ZS_SFYXXGXM','ZS_YTZLDZSFKYCX','ZS_YZWHJMMRYZLB','ZS_SFTSMRCYBR','ZS_SJWDSFKCJ','ZS_CJZDTZLJYZ','ZS_WLJBRZBSRZLXMID','ZS_YBBRFYTSJE','ZS_NBBRFYTSJE','ZS_KJXCYLSYZSZLSFBYXBJ','ZS_KJXCYLSYZSSFSYTSXZ','ZS_CRBDJSFQZSR','ZS_BAQHJGTS','ZS_SFKYYJSYKSSYP','ZS_ZYBAJKSFZNCSYSHBA','ZS_SFSYYZYTZGN','YS_MBWHSFXZDYF')

121     08:36:38  SQL Prepare: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

122     08:36:38  SQL Execute: ORACLE - select ybzxlb, ybbrlb, fbbh00 from bm_ybbrlb where BRLBMC='福建省长乐市新农合管理中心'

123     08:36:39  SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 1143

124     08:36:39  SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM')
 and YGBH00 = 1143

125     08:36:39  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

126     08:36:39  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%'

127     08:36:39  SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

128     08:36:39  SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF')

129     08:36:39  SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=1143

130     08:36:39  SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=1143

131     08:36:39  SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='3'

132     08:36:39  SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='3'

133     08:36:39  SQL Prepare: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

134     08:36:39  SQL Execute: ORACLE - select BZ0000 from BM_TYZD00 where ZDMC00='智方危机值配置' AND YXBZ00='1' and MC0000='刷新间隔' 

135     08:36:46  SQL Prepare: ORACLE - SELECT  A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM 
FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) 
 ORDER BY RYCWH0

136     08:36:46  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.000000
137     08:36:46  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 23.000000
138     08:36:46  SQL Execute: ORACLE - SELECT  A.ZYID00,A.MRN000,A.ZYH000,A.RYCWH0,A.XM0000,A.XB0000,A.CJRQ00,A.CJSJ00,A.BRZT00,A.ZZYS00, A.ZRYS00, A.SXYS00, A.RYRQ00,A.CYDJRQ,A.DQLJID,a.CJYSXM 
FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) 
 ORDER BY RYCWH0

139     08:36:54  SQL Prepare: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0)

140     08:36:54  SQL Execute: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0)

141     08:36:57  SQL Prepare: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,947808,942863,944265,944269,747057,933006,938757,944757,945109,944270,942171,945867,944606,945878,948458,945865,932165,928957,942175,928508,945857,926960,945171,945724,944610,945161,938506,945719,942866,944161,947456,944160,944808,947806,947208,945860,947906,943708,943510,948760,945175,922156,946506,944261,947960,947959,945960,946006,947206,838508,947958,933757,848260)

142     08:36:57  SQL Execute: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,947808,942863,944265,944269,747057,933006,938757,944757,945109,944270,942171,945867,944606,945878,948458,945865,932165,928957,942175,928508,945857,926960,945171,945724,944610,945161,938506,945719,942866,944161,947456,944160,944808,947806,947208,945860,947906,943708,943510,948760,945175,922156,946506,944261,947960,947959,945960,946006,947206,838508,947958,933757,848260)

143     08:37:48  SQL Prepare: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,926159,943407,900356,903813,903967,865059,932057,932068,942059,903160,936206,887409,910201,910463,881207,931460,931756,893757,908306,882506,930764,933958,879006,929807,932360,887117,887356,888156,915507,876458,924706,932860,885709,900911,871607,943006,903858,884257,932072,934166,889806,897508,904357,904365,906256,910806,919857,884357,925822,931458,931513,910608,883606,944264,945157,886707,904263,904456,921057,882807,886509,897859,898212,919706,862314,884411,926758,932576,942414,887357,894856,884857,853956,901064,906356,910460,915106,921557,932124,932567,933369,942358,887108,891059,892461,899525,903963,905656,909857,910061,874206,880712,899610,909858,918906,882008,884507,929856,857606,945164,899457,875710,931425,901106,893061,911620,926957,943263,899107,910807,913306,915356,881759,931907,893908,906206,948416,888256,889661,887306,898211,917157,880808,851410,931515,941971,904062,915406,921012,931209,932858,933159,880307,880958,904157,908108,910709,934607,855416,885609,897906,913156,919407,921109,934556,937556,869606,886910,887257,894507,897706,899521,909765,925817,933406,900256,941057,866360,877906,902657,924956,925821,941960,944064,878258,889807,932584,942406,868408,887010,896806,935556,944066,912206,882357,886506,899458,931414,941978,942606,943010,873758,903106,925206,931417,876408,885006,899557,904066,858660,873606,890458,908456,920957,938656,865906,892506,910615,921608,931107,907820,876207,888307,898307,906456,915056,930760,931577,933617,933966,945407,871857,895006,901958,928307,932915,933020,933021,865959,894206,942608,876056,887109,904707,905357,910165,910312,931358,932358,933056,941256,882857,885156,897806,899656,906557,910199,920207,927556,933007,880706,886410,888709,891408,932029,894606,903510,915360,924510,887507,931510,892207,861158,891356,894659,910506,883207,893656,911956,887410,942867,890813,902956,908164,921156,931512,945167,942869,944910,890206,897356,898207,902656,906007,921010,929656,942859,866106,888707,898208,922057,929456,885507,889106,899860,902906,908256,930763,934309,882760,903961,911262,930707,937406,883056,899612,945173,946156,883306,888008,944911,883406,892756,900056,920962,926656,904058,915107,930762,889907,908412,942864,898214,932833,915306,931564,932828,945723,894306,930765,899664,922059,944806,898257,903107,903358,910509,912256,915806,921111,919158,878256,932015,929306,921159,910856,904070,908426,931913,945874,910180,885606,888107,891359,891407,894657,897207,903959,903971,905709,911609,918507,919356,856176,943609,947907,871608,883156,898807,903815,903956,908106,910310,912556,916160,926157,928807,933963,947913,921011,924513,926858,858958,860458,910167,931706,903456,908415,930207,931807,932308,945108,884806,888558,911409,911615,934558,901060,932037,932564,933968,882557,883456,904068,904706,926856,855958,874106,880256,891009,902208,910410,933363,933708,941907,945006,898209,904065,924656,937056,880816,893006,869513,941970,876559,882560,883956,885509,893009,914256,931457,931517)

144     08:37:48  SQL Execute: ORACLE - SELECT BRID00,ZYID00,MRN000,ZYH000,XM0000,XB0000,CSRQ00,
RYZD00,RYSQK0,RZKS00,RYCWH0,BMMC00,RYRQSJ,FBMC00,
ZRYS00,ZZYS00,SXYS00,SHBZ00,decode(SHBZ00,'1','提交','2','通过','3','未通过','0','未提交','9','未创建') SHBZMC FROM VW_ZS_SCBLBR A 
WHERE zyid00 in (0,926159,943407,900356,903813,903967,865059,932057,932068,942059,903160,936206,887409,910201,910463,881207,931460,931756,893757,908306,882506,930764,933958,879006,929807,932360,887117,887356,888156,915507,876458,924706,932860,885709,900911,871607,943006,903858,884257,932072,934166,889806,897508,904357,904365,906256,910806,919857,884357,925822,931458,931513,910608,883606,944264,945157,886707,904263,904456,921057,882807,886509,897859,898212,919706,862314,884411,926758,932576,942414,887357,894856,884857,853956,901064,906356,910460,915106,921557,932124,932567,933369,942358,887108,891059,892461,899525,903963,905656,909857,910061,874206,880712,899610,909858,918906,882008,884507,929856,857606,945164,899457,875710,931425,901106,893061,911620,926957,943263,899107,910807,913306,915356,881759,931907,893908,906206,948416,888256,889661,887306,898211,917157,880808,851410,931515,941971,904062,915406,921012,931209,932858,933159,880307,880958,904157,908108,910709,934607,855416,885609,897906,913156,919407,921109,934556,937556,869606,886910,887257,894507,897706,899521,909765,925817,933406,900256,941057,866360,877906,902657,924956,925821,941960,944064,878258,889807,932584,942406,868408,887010,896806,935556,944066,912206,882357,886506,899458,931414,941978,942606,943010,873758,903106,925206,931417,876408,885006,899557,904066,858660,873606,890458,908456,920957,938656,865906,892506,910615,921608,931107,907820,876207,888307,898307,906456,915056,930760,931577,933617,933966,945407,871857,895006,901958,928307,932915,933020,933021,865959,894206,942608,876056,887109,904707,905357,910165,910312,931358,932358,933056,941256,882857,885156,897806,899656,906557,910199,920207,927556,933007,880706,886410,888709,891408,932029,894606,903510,915360,924510,887507,931510,892207,861158,891356,894659,910506,883207,893656,911956,887410,942867,890813,902956,908164,921156,931512,945167,942869,944910,890206,897356,898207,902656,906007,921010,929656,942859,866106,888707,898208,922057,929456,885507,889106,899860,902906,908256,930763,934309,882760,903961,911262,930707,937406,883056,899612,945173,946156,883306,888008,944911,883406,892756,900056,920962,926656,904058,915107,930762,889907,908412,942864,898214,932833,915306,931564,932828,945723,894306,930765,899664,922059,944806,898257,903107,903358,910509,912256,915806,921111,919158,878256,932015,929306,921159,910856,904070,908426,931913,945874,910180,885606,888107,891359,891407,894657,897207,903959,903971,905709,911609,918507,919356,856176,943609,947907,871608,883156,898807,903815,903956,908106,910310,912556,916160,926157,928807,933963,947913,921011,924513,926858,858958,860458,910167,931706,903456,908415,930207,931807,932308,945108,884806,888558,911409,911615,934558,901060,932037,932564,933968,882557,883456,904068,904706,926856,855958,874106,880256,891009,902208,910410,933363,933708,941907,945006,898209,904065,924656,937056,880816,893006,869513,941970,876559,882560,883956,885509,893009,914256,931457,931517)

145     08:38:41  SQL Prepare: ORACLE - BEGIN "SP_ZS_CJBASY" (PZYID00 => :PZYID00,PCZY000 => :PCZY000); END;
146     08:38:41  SQL Data In: ORACLE - Param = 1, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 907820.000000
147     08:38:41  SQL Data In: ORACLE - Param = 2, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1143.000000
148     08:38:41  SQL Execute: ORACLE - BEGIN "SP_ZS_CJBASY" (PZYID00 => :PZYID00,PCZY000 => :PCZY000); END;
149     08:38:41  SQL Prepare: ORACLE - rollback

150     08:38:41  SQL Execute: ORACLE - rollback

151     08:38:41  SQL Data In: ORACLE - Rows affected = 0