1 15:04:33 Log started for: SQL Navigator for Oracle 2 15:04:59 Log started for: 住院医生工作站系统 3 15:04:59 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') RQ,to_char(sysdate,'HH24:MI:SS') SJ,SID,serial# from v$session where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 4 15:04:59 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.240','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101224','15:05:00','scott@0006:72DB8E6015B28DA3C9AFF3F1A75438D1' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 5 15:04:59 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.240','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101224','15:05:00','scott@0006:72DB8E6015B28DA3C9AFF3F1A75438D1' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 6 15:04:59 SQL Data In: ORACLE - Rows affected = 1 7 15:04:59 SQL Prepare: ORACLE - Commit 8 15:04:59 SQL Execute: ORACLE - Commit 9 15:04:59 SQL Data In: ORACLE - Rows affected = 0 10 15:04:59 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 11 15:04:59 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 12 15:04:59 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222147' 13 15:04:59 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222147' 14 15:04:59 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='0006' and CZBZ00 in ('1') 15 15:04:59 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='0006' and CZBZ00 in ('1') 16 15:04:59 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.240','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101224','15:05:00','sd_hospital@0006:62CA20EC9FD6E6ECC5BF8115A749A116' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 17 15:04:59 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.0.240','Z',trim(PROGRAM)||'+'||'住院医生工作站系统',SID,serial# ,'20101224','15:05:00','sd_hospital@0006:62CA20EC9FD6E6ECC5BF8115A749A116' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 18 15:04:59 SQL Data In: ORACLE - Rows affected = 1 19 15:04:59 SQL Prepare: ORACLE - Commit 20 15:04:59 SQL Execute: ORACLE - Commit 21 15:04:59 SQL Data In: ORACLE - Rows affected = 0 22 15:04:59 SQL Prepare: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 23 15:04:59 SQL Execute: ORACLE - delete XT_XTLJ00 where LJRQ00<=to_char(sysdate-3,'YYYYMMDD') and rownum<=500 24 15:04:59 SQL Data In: ORACLE - Rows affected = 0 25 15:04:59 SQL Prepare: ORACLE - Commit 26 15:04:59 SQL Execute: ORACLE - Commit 27 15:04:59 SQL Data In: ORACLE - Rows affected = 0 28 15:04:59 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 29 15:04:59 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='Z' 30 15:04:59 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0006' and CZBZ00 in ('1') 31 15:04:59 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='0006' and CZBZ00 in ('1') 32 15:04:59 SQL Prepare: ORACLE - Select SYSDATE from Dual 33 15:04:59 SQL Execute: ORACLE - Select SYSDATE from Dual 34 15:04:59 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 35 15:04:59 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 36 15:04:59 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 37 15:04:59 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='Z' 38 15:04:59 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 39 15:04:59 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 40 15:04:59 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 41 15:05:00 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 42 15:05:00 SQL Prepare: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('0','1','2','3','4','5') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0006')) order by BH0000 43 15:05:00 SQL Execute: ORACLE - Select BMMC00,BMBH00 from BM_BMBM00 where FLAG00='1' and BMXZ00 in ('0','1','2','3','4','5') and BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='Z' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='0006')) order by BH0000 44 15:05:00 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '0006'='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)='0006')) 45 15:05:00 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '0006'='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)='0006')) 46 15:05:00 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=24 47 15:05:00 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=24 48 15:05:00 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 49 15:05:00 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 50 15:05:00 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 51 15:05:00 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 52 15:05:00 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 53 15:05:00 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 54 15:05:00 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 55 15:05:00 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 56 15:05:00 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')) 57 15:05:00 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')) 58 15:05:00 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2008819,24,'dns','Z',nvl('401491',' '),'192.168.0.240#244:1857@ZY_YS.exe+住院医生工作站系统',25) 59 15:05:00 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(2008819,24,'dns','Z',nvl('401491',' '),'192.168.0.240#244:1857@ZY_YS.exe+住院医生工作站系统',25) 60 15:05:00 SQL Data In: ORACLE - Rows affected = 1 61 15:05:00 SQL Prepare: ORACLE - Commit 62 15:05:00 SQL Execute: ORACLE - Commit 63 15:05:00 SQL Data In: ORACLE - Rows affected = 0 64 15:05:00 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 25 65 15:05:00 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 25 66 15:05:00 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222147' 67 15:05:00 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00 from XT_YYXX00 where YYID00= '222147' 68 15:05:00 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.240' 69 15:05:00 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.0.240' 70 15:05:00 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 71 15:05:00 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 72 15:05:00 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 25 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 73 15:05:00 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 25 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 74 15:05:00 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20101224' 75 15:05:00 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='Z') and YXQ000>='20101224' 76 15:05:00 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 77 15:05:00 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 78 15:05:00 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 79 15:05:00 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 80 15:05:01 SQL Prepare: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 81 15:05:01 SQL Execute: ORACLE - Select SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 82 15:05:02 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 83 15:05:02 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_FTPXX0 a 84 15:05:02 SQL Prepare: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 85 15:05:02 SQL Execute: ORACLE - SELECT a.*, to_char(sysdate,'YYYYMMDD') TODATE0 FROM ZS_BLLJMS a 86 15:05:02 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='Z' and (( 24= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=24)))) 87 15:05:02 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='Z' and (( 24= 0) or (BZ0000<>'0' and MKDM00 in (select MKDM00 from XT_ZBQX00 where XTDM00='Z' and ZBDM00 in ( select ZBDM00 from VW_XT_YHZB00 where YGBH00=24)))) 88 15:05:03 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 89 15:05:03 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 90 15:05:03 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 ((24= 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=24)))) 91 15:05:03 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 ((24= 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=24)))) 92 15:05:03 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 93 15:05:03 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 94 15:05:03 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 24= 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=24)))) 95 15:05:03 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' and (( 24= 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=24)))) 96 15:05:03 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 97 15:05:03 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_ZS_%' AND STATUS<>'VALID' 98 15:05:03 SQL Prepare: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 99 15:05:03 SQL Execute: ORACLE - select Trigger_Name from all_triggers where status<>'ENABLED' AND Trigger_NAME LIKE 'TR_ZS_%' 100 15:05:03 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','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB') 101 15:05:04 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','ZS_DMCFSFZXZFS','ZS_QKYHDJSFHB') 102 15:05:04 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 24 103 15:05:04 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('IPTDRT','HZSRF0','FZSRF0','RTNRUM') and YGBH00 = 24 104 15:05:04 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 105 15:05:04 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_LEN_%' 106 15:05:05 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 107 15:05:05 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 LIKE 'ZS_BL_PAGE%' or name00 in ('ZS_BLDBKSYSKF') 108 15:05:05 SQL Prepare: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=24 109 15:05:05 SQL Execute: ORACLE - select * from VW_BQ_YSBM00 where ygbh00=24 110 15:05:05 SQL Prepare: ORACLE - select * from bm_yslb00 where yslb00='2' 111 15:05:05 SQL Execute: ORACLE - select * from bm_yslb00 where yslb00='2' 112 15:05:20 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 FROM VW_ZS_YJBLXX A WHERE (DQKS00=:1 or DQBQ00=:2) ORDER BY RYCWH0 113 15:05:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 114 15:05:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 25.000000 115 15:05:20 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 FROM VW_ZS_YJBLXX A WHERE (DQKS00=? or DQBQ00=?) ORDER BY RYCWH0 116 15:05:26 SQL Prepare: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,WJSJE0,decode(sfdj00,'0','正常','1','冻结','停用') sfdj00 from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134 117 15:05:26 SQL Execute: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,WJSJE0,decode(sfdj00,'0','正常','1','冻结','停用') sfdj00 from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134 118 15:05:26 SQL Error: ORACLE - ORA-01795: 列表中的最大表达式数为 1000 119 15:05:26 SQL Error: ORACLE - Unmapped SQL Error Code: 1795 120 15:05:26 SQL Data In: ORACLE - Rows affected = 0 121 15:05:29 SQL Prepare: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,Decode(sfdj00,'0','正常','1','冻结','停用')"sfdj00" from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134703,11 122 15:05:29 SQL Execute: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,Decode(sfdj00,'0','正常','1','冻结','停用')"sfdj00" from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134703,11 123 15:05:29 SQL Error: ORACLE - ORA-01795: 列表中的最大表达式数为 1000 124 15:05:29 SQL Error: ORACLE - Unmapped SQL Error Code: 1795 125 15:05:29 SQL Data In: ORACLE - Rows affected = 0 126 15:05:32 SQL Prepare: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,Decode(sfdj00,'0','正常','1','冻结','停用')"sfdj00" from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134703,11 127 15:05:32 SQL Execute: ORACLE - select zyh000,rycwh0,xm0000,jflbmc,zye000,ykzye0,KYJE00,jflbid,brid00,YBMC00,YBQFBZ,YBZFBL,tyje00,bjje00,YBYJS0,YBYZF0,YBZHYE,YJJE00,Decode(sfdj00,'0','正常','1','冻结','停用')"sfdj00" from VW_BQ_YBZHXX where substr(brzt00,1,1)='2' and zyid00 in (0,183402,29355,193402,194752,202352,205152,206302,152002,154602,167302,173502,178052,180862,95052,98503,101052,103503,103802,104452,106904,108803,112702,116602,123652,125404,130002,134902,143104,64452,65252,67804,71455,73152,75802,83802,84652,92553,30852,33352,41303,42302,43954,48702,63402,63502,97,139,851,2301,16002,16802,19105,21556,22252,23152,26255,189352,184952,28353,190303,196052,202452,206503,144552,147802,154502,155602,155653,157654,159452,165054,169152,175502,97202,101402,106952,108853,126652,133103,134704,141102,65053,74053,81754,93802,33402,43752,57203,58302,80,2451,3351,9403,11803,17155,21555,27952,188502,184302,3905,191353,195653,202454,203853,207353,208702,143605,146854,156902,164152,94552,107002,125454,75458,78652,81454,85310,48102,53852,188252,186702,5002,191052,144705,148453,180052,94153,104953,116552,76602,81802,87253,48253,49952,190606,186156,26402,188102,190103,192002,196652,202503,209253,153053,160152,164302,178652,180353,96254,104803,109352,128402,131452,143352,73952,85602,89803,30753,34603,40503,50302,54152,60202,127,2501,3402,5952,6002,6853,7302,8952,9553,21552,186754,182152,186055,192252,149702,156903,161902,169902,177904,104852,112802,119552,133102,143052,74402,80952,82352,91802,34702,40506,47202,57003,2954,5053,7602,11104,21553,26552,187452,30153,197102,201003,203854,210052,147304,155703,161402,165102,181952,95002,99052,108053,112103,133002,143552,65902,73954,82152,93555,30403,34402,41054,46152,53503,9703,16102,21554,27002,193902,4551,78852,3302,95803,15352,165953,57202,161403,156352,52902,21557,145852,144353,85311,210302,47103,82403,196902,195752,191204,42002,186352,69154,183602,11102,34403,93652,104902,126153,95852,173602,161953,155652,146803,210653,203802,198903,188152,184152,10252,65852,8302,2401,51302,49553,45953,41702,33802,90403,85953,82402,76152,72853,27704,9652,11852,76502,81453,86352,31602,35853,41954,46252,52352,2701,3051,10203,185302,188603,190302,191302,202152,143952,149852,163503,164052,173253,98052,100952,104652,66453,9803,144703,202,87003,184252,194404,50653,15652,202753,76552,166304,102552,31552,120852,41855,163052,96602,3551,54353,49352,44953,36302,92352,87052,83552,81455,76304,65953,140802,135252,118002,172703,162202,150107,145502,74003,52203,42452,90902,166804,66003,82404,78902,115153,148402,140653,144852,45102,48053,52152,191552,134752,187003,26602,145602,162152,94355,108353,66002,76902,85306,85307,89952,39653,42252,45652,47102,54202,58103,191553,208753,5403,199602,161452,150903,152252,156202,137852,141352,145302,130702,134653,120753,122603,123202,115402,103605,106653,106702,91953,95502,84452,87004,56552,61552,24902,26302,14202,18754,20002,128,195352,207254,33053,194566,167952,148953,156402,138552,129002,133602,120453,122902,112952,116752,106602,76803,82903,69153,56103,65102,42253,46203,49105,28402,28952,190653,189502,129,195652,182704,173002,151353,143152,133902,122952,126602,114752,102952,96452,67602,70752,55153,60856,46302,14752,15003,19703,191352,201352,137,195252,175003,183753,186902,159952,163702,155752,157503,137052,125503,111202,99303,87855,97152,85652,67352,70702,74453,74752,53002,63352,44002,48352,20902,24353,25302,17552,203352,202754,7452,189652,193702,175606,169302,130252,136453,126902,99902,108202,95752,98552,79902,84102,70653,59902,65952,38003,41952,44054,28653,32753,36452,21152,23303,25152,11452,13902,105,2956,208752,201902,16252,175302,180256,184002,160002,173555,138052,131302,133703,124403,110903,103752,94002,80903,85052,72002,58502,61752,31002,20202,23003,25352,188703,21802,22902,13103,15152,95,130,3251,5652,6902,7853,134352,135354,135803,136152,119152,125253,125652,127352,110052,111802,113004,113154,113902,115154,115252,116052,99252,99302,99704,100153,100302,106905,88002,88004,89503,90054,91203,92253,92803,94302,95802,96652,97603,98902,77002,77552,78002,81552,83102,83202,84853,85308,85902,87152,69702,70452,71904,72104,73303,74102,74152,74652,76154,76453,56152,58652,61152,63652,65853,39102,40352,28652,31702,32652,200702,201706,202302,204453,206452,209153,190402,190403,191202,191452,193102,193603,193807,195403,195702,196402,197902,198052,198453,199552,200653,175103,177952,178802,181302,182052,182352,183302,184752,185352,186052,187303,187502,187802,158802,160052,160102,161554,163352,163803,167452,168302,169153,169205,169652,170703,171202,173802,151354,151553,154052,155404,158754,138352,138957,140203,142653,143053,143057,144152,146559,128702,129804,134103,201707,203703,189303,190502,191503,192303,194202,196403,196404,197353,197904,197952,199853,174452,176853,178152,178302,179202,180203,182202,184852,185103,185502,186602,188452,158952,163002,163204,163853,164852,168452,169202,170704,172202,149402,150202,151452,151902,156052,156502,140204,142702,135402,118555,124753,127903,128103,111002,113852,114059,114252,115202,116005,99552,107452,108252,90102,90552,92952,79002,80504,81502,82252,82802,83354,83902,68102,69256,69952,71205,72952,73502,74002,75252,53502,54103,56554,57102,57702,60703,60803,62302,65502,38252,38602,48302,51403,51504,52202,26854,30602,31202,31502,33552,36052,25402,26002,12502,16853,18902,1902,8103,205902,1251,177652,180152,152054,145403,130902,135902,128253,94502,78302,64254,38353,42402,29604,20552,23953,11802,16952,205952,131,148152,26502,28302,30552,21402,25154,12202,14052,79003,72052,60053,64302,39353,42352,109803,118052,144002,129754,136202,123504,123703,204903,209052,210703,193252,198653,181803,161854,164902,51652,118,148603,28352,33852,20502,24303,14854,77102,80252,83002,72703,66103,112303,103204,108702,91352,154553,140153,145904,130502,136402,119707,209203,209503,189253,190654,175607,132,133,148703,15252,71203,75102,45052,111902,115052,101952,93202,97604,152253,138303,139502,141152,128752,130852,134402,119252,209102,189252,181652,173254,7402,19753,182103,4102,8402,29153,35852,20852,25754,85152,58902,65903,124102,128254,100052,102105,104703,105452,105802,90452,92953,152402,146653,134802,118654,202602,208002,177455,138,1202,174403,4801,33252,23453,10253,14754,17452,18652,76455,71103,59602,61253,38402,44102,102153,109503,87952,91654,140554,129152,134452,134606,135202,119453,202052,204802,205603,209602,198452,179403,169402,2102,134,149905,4961,29453,37352,22304,23952,26202,10502,15602,19404,77752,84552,70402,73003,55502,60602,62753,42502,47502,124052,125903,127553,101252,103102,91354,92402,94402,98302,137452,141402,129553,131254,204502,190852,194402,200553,174552,177454,159358,163202,163402,163603,170202,1401,19502,135,6602,7752,47702,52603,26952,30652,24752,10953,16202,81952,86302,74456,53152,59704,66752,38052,125653,111453,112305,114054,114302,118102,101253,104402,105902,106202,89956,94352,98153,98952,152854,153202,154302,158604,140303,143062,130352,132303,123153,203252,206152,189905,197852,1802,163802,32353,23053,24453,26254,10552,15102,80502,81456,84803,67852,68952,76303,63853,116852,108804,93503,156252,143102,147852,133054,136403,120953,206252,194568,178702,162102,7252,140,174002,8804,51352,28453,30102,37505,21704,22753,25054,25902,13602,17902,78154,80753,68753,72102,54354,56702,60302,66202,46102,124302,127152,109802,111302,117054,104453,93902,152955,146557,147752,130552,130602,130803,133702,120754,204002,209802,189902,180855,182302,162602,168402,1752,57,151552,1302,1601,48003,50303,29053,33803,20103,24253,25102,10702,14852,77402,69253,76002,58153,61654,62702,37652,41502,47003,127652,111152,108456,92452,95702,96103,99152,155253,158053,146902,129202,130659,133053,135152,121602,195552,162703,125,17154,148802,4602,31052,33703,35453,36902,20802,24152,25002,26252,10452,87752,69002,71253,72702,64052,38102,38952,42703,102106,106502,108105,94252,76952,77153,132452,123802,126553,127403,111257,111405,114953,118302,149752,151002,151604,153953,155202,137703,143603,131552,205954,194852,177552,181352,186752,159152,161352,168202,174352,115,13352,123,4751,5154,8803,50752,28155,35652,21902,23752,24953,25453,73153,56302,58802,65104,40502,45152,99452,101352,105752,109558,92206,96803,78602,84602,132552,134703,11 128 15:05:32 SQL Error: ORACLE - ORA-01795: 列表中的最大表达式数为 1000 129 15:05:32 SQL Error: ORACLE - Unmapped SQL Error Code: 1795 130 15:05:32 SQL Data In: ORACLE - Rows affected = 0