1 17:13:37 Log started for: 门诊挂号收费管理系统 2 17:13:37 SQL Prepare: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20120716','17:13:27','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 3 17:13:37 SQL Execute: ORACLE - Insert into sd_hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20120716','17:13:27','scott@9998:63EE1B8593BA087C2E8C1F5BF7822869' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 4 17:13:37 SQL Data In: ORACLE - Rows affected = 1 5 17:13:37 SQL Prepare: ORACLE - Commit 6 17:13:37 SQL Execute: ORACLE - Commit 7 17:13:37 SQL Data In: ORACLE - Rows affected = 0 8 17:13:37 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 17:13:37 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 17:13:37 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 17:13:37 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 17:13:37 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 13 17:13:37 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 14 17:13:37 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20120716','17:13:27','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 15 17:13:37 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.12.120','4',trim(PROGRAM)||'+'||'门诊挂号收费管理系统',SID,serial# ,'20120716','17:13:27','sd_hospital@9998:9F6C4AA856D1E4809F23DD2030F70576' from v$session where AUDSID=(Select userenv('SESSIONID') from dual where rownum=1) 16 17:13:37 SQL Data In: ORACLE - Rows affected = 1 17 17:13:37 SQL Prepare: ORACLE - Commit 18 17:13:37 SQL Execute: ORACLE - Commit 19 17:13:37 SQL Data In: ORACLE - Rows affected = 0 20 17:13:37 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 21 17:13:37 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='4' 22 17:13:37 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 23 17:13:37 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='9998' and CZBZ00 in ('1') 24 17:13:37 SQL Prepare: ORACLE - Select SYSDATE from Dual 25 17:13:37 SQL Execute: ORACLE - Select SYSDATE from Dual 26 17:13:37 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 27 17:13:37 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 28 17:13:37 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 29 17:13:37 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 30 17:13:37 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 31 17:13:37 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='4' 32 17:13:37 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 33 17:13:37 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 34 17:13:37 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 35 17:13:37 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 36 17:13:37 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 37 17:13:37 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('4') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) order by b.PLXH00,a.BH0000 38 17:13:37 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 39 17:13:37 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '9998'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '4' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='4' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='9998') 40 17:13:37 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 41 17:13:37 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=476 42 17:13:37 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 43 17:13:37 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 44 17:13:37 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 45 17:13:37 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 46 17:13:37 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 47 17:13:37 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 48 17:13:37 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 49 17:13:37 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 50 17:13:37 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 51 17:13:37 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 52 17:13:37 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3122169,476,'wlzx-3','4',nvl('38652215',' '),'192.168.12.120#732:10386@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 53 17:13:37 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3122169,476,'wlzx-3','4',nvl('38652215',' '),'192.168.12.120#732:10386@PrjMZ_MZSF.exe+门诊挂号收费管理系统',44) 54 17:13:38 SQL Data In: ORACLE - Rows affected = 1 55 17:13:38 SQL Prepare: ORACLE - Commit 56 17:13:38 SQL Execute: ORACLE - Commit 57 17:13:38 SQL Data In: ORACLE - Rows affected = 0 58 17:13:38 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 59 17:13:38 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 44 60 17:13:38 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 61 17:13:38 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 62 17:13:38 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 63 17:13:38 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 64 17:13:38 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 65 17:13:38 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.12.120' 66 17:13:38 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 67 17:13:38 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('XT_SQIPDZ','YF_CKJRZTXG') 68 17:13:38 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 69 17:13:38 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 44 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 70 17:13:38 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 71 17:13:38 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 72 17:13:38 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 73 17:13:38 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 74 17:13:38 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 75 17:13:38 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='476' and name00='SYSTEMSKIN' 76 17:13:38 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20120716' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 77 17:13:38 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where (XTDM00='-1' or XTDM00='4') and YXQ000>='20120716' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',44,' )>0 ) 78 17:13:38 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 79 17:13:38 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 80 17:13:38 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 81 17:13:38 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 82 17:13:39 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='4'))) 83 17:13:39 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='4' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='4'))) 84 17:13:39 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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 85 17:13:39 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '4$%' and A.XTDM00='4' and trim(A.MKDM00)='4$'||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 86 17:13:39 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 87 17:13:39 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 ((476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='0 '))) 88 17:13:39 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 89 17:13:39 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 90 17:13:39 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 91 17:13:39 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 476= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=476 and XTDM00='+ '))) 92 17:13:40 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 93 17:13:40 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 94 17:13:40 SQL Prepare: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 95 17:13:40 SQL Execute: ORACLE - Update SF_BRDB00 set SFYX00='N' where DBJSRQ < to_char(sysdate,'yyyymmdd') and SFYX00 = 'Y' 96 17:13:40 SQL Data In: ORACLE - Rows affected = 0 97 17:13:40 SQL Prepare: ORACLE - Commit 98 17:13:40 SQL Execute: ORACLE - Commit 99 17:13:40 SQL Data In: ORACLE - Rows affected = 0 100 17:13:40 SQL Prepare: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 101 17:13:40 SQL Execute: ORACLE - select count(*) NUM from user_triggers where 1 = 1 and trigger_name in ('TR_SF_SF_BRFY00_INSERT','TR_SF_SF_BRJFB0_INSERT', 'TR_SF_SF_BRDB00_UPDATE','TR_SF_SF_PJSYQK_INSERT', 'TR_SF_SF_BRJFB0_UPDATE','TR_SF_SF_BRXXB0_INSERT','TR_SF_SF_PJSYQK_INSERT') and STATUS = 'ENABLED' 102 17:13:40 SQL Prepare: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 103 17:13:40 SQL Execute: ORACLE - select * from bm_brzffs where ZFFSMC = '现金' 104 17:13:40 SQL Prepare: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 105 17:13:40 SQL Execute: ORACLE - select count(*) NUM from bm_brjflb where jflbid=0 or sybz00 = '0' or sybz00 = '1' 106 17:13:40 SQL Prepare: ORACLE - select sysdate nowtime from dual 107 17:13:40 SQL Execute: ORACLE - select sysdate nowtime from dual 108 17:13:40 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 109 17:13:40 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00 = 476 110 17:13:40 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 111 17:13:40 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('SF_YBSFYGSSYLB','SF_MZFPSFDYYJJYE','SF_YBJSSAZTSBZ','SF_FYJSWSFTSWJSFY','MZSF_SFTSDYZSFP','SF_CJFY','SF_PRINTGHHFZDXZDY','SF_MZQDSFXSJMJE','SF_MZJSSFKYCZTYDW','SF_YHKLB','SF_GHXXSFTXJT','SF_FYJSSFXXZTSBZ','SF_GHLBBH','SF_GHXMBH','SF_PJQKSFDYFS','SF_SFSYFPXMZMYHJM','SF_FPGS00','SF_YYIDPDDLKS','SF_TSBZ_SFMRSCJZTSBZ','SF_TSBZ_SFZJSBTSBZFY','SF_FYDJSFXSGQGH','SF_YBFYDJSFZDBSDJF','SF_MZFPSFXSTSBZ','SF_MZRQDSFXSZHYE','SF_MZLSCFSFCSMFH','SF_LSCLSFXZ','SF_SFQYAKYYGH','SF_YJJDLEFTTOP','SF_TYJJDLEFTTOP','SF_DYBRXX_TOPLEFT','MZSF_YJJGHFB','SF_GHCKNLDYS','SF_GHCKSFTSZFCK','SF_SFKYQZTKCZ','SF_KP_SFQDZRXDTS','SF_BRGKSFXSMMK','SF_GRZFSFBHSB','SF_SFYJXGSJQY','SF_SFYXSFCDLYJXM','SF_PJWLYBNSY','SF_SFYXCKDQPJH','SF_YJXMYXTS','SF_CSBSYBFPSFFKCL','SF_RQDZFBLSFTXNJYY','SF_YBZGTJHSFYZMTJJK','MZSF_SFJSTXJKYCX','SF_MZFPSFXSQYXX','SF_SFHANHTSBZBR','SF_YBJKSFXDYNK','SF_FPBDJSRQSFXSQSRQ','SF_BJJESFBKKQFJE','SF_JSJZTKFPSFXSQZQYJJYE','SF_LSTDBRFB','SF_GHJFYCLXJBRZYXYXJZFFS','SF_YBGRZHZWYXQFJE') 112 17:13:40 SQL Prepare: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 113 17:13:40 SQL Execute: ORACLE - select name00,value0 from XT_XTCS00 where NAME00 in ('ZY_JSSRTDXXTJBBSFCF','ZY_JSSRTDXXTJBBCFLS','ZY_JSSRTDXXTJBBCFHS','GHYXTS','YJ_XMYXTS','SF_PJHSC0','SF_DYYBFP','SF_MZBLH0','XT_JEQZ00','XT_YBJEQZ','SF_ZHTYJE','SF_ZHBJJE','SF_PJDKDY','YF_CFZJE_SRWS_YB','YF_CFZJE_CZFS_YB','YF_CFMXJE_SRWS','YF_YZMXJE_SRWS','YF_CFZJE_SRWS','YF_CFZJE_CZFS','YF_CFMXJE_CZFS','YF_YZMXJE_CZFS','SF_SFYJS0_BZ0000','SF_GHD000_PRINT0','SF_PRINTSCALE','SF_TKPAR0_CZY000','SF_PARAMS_GHYXTS','ZY_RQDZZ0_SETUP0','SF_PageWidth','SF_PageHeigh','SF_PageDirect','SF_GHDLX0','SF_GHDSFTD','SF_JHFPSFTD','SF_SFSYJZK','SF_TJKSSJ','SF_TJJSSJ','SF_SFGLGZGHD','SF_YBGHFJF','SF_YBBRXB','SF_FPWidth','SF_FPHeigh','SF_NEWFPWidth','SF_NEWFPHeigh','SF_GHDWidth','SF_GHDHeigh','YF_ZYFJF_YPNM00','ZY_PJLYXYLYQR','SF_GHXGSFBRCZ','SF_JKDSFTD','SF_JKDJSFZDJS','SF_JKSFAJJBSJ','SF_NEWFPGS','SF_MZSFJJBSJ','SF_SYDJSBBGBF','SF_FYBXMSFSYYBBH','SF_GHCZSBBGBF','SF_MZJKDGS0','SF_YJJDGS0','SF_FYJSMR0','IC_YBYYJKLM','SF_COMMIT_READICK','SF_YBDJSLJE','SF_SFSYICK','SF_FPLXBZ0','XT_YBFSJK','XT_SGLRKH','XT_XYCYTCF','SF_XJGHSK','SF_BLHSFZDSC','SF_MZBLSYGS','XT_GZYJJYXTJK','SF_KHBLHXT','SF_SSWUTSCL','SF_SFCYSSWR','SF_HKSFTF0','SF_SFTKZDSP','SF_SFDYQD','SF_GHSSFSBLDGGH','SF_SFCFFP','SF_DYQBFP','SF_SFPDYB_CF0000','SF_ZY_SFZDXS','ZY_YJJPJ0','SF_SFSYYBYKT','SF_XJJSSFDYZHYE','SF_SFSYYGKJ','SF_KFSFKQ','SF_YBSFYXQF','ZY_YBFPBH','SF_CKBRSYGHD','IC_SFDM','SF_SFTSWF','SF_YBSFAGHDJS','SF_SFYDDYJ','SFYBZHYE','SF_MZYJJXZ','SF_SFDYTSJKD','SF_MZJSTSNY','SF_SFZDTJYJD','SF_TYJJDYYE','SF_SFDYZLD','SF_SFSYJZSX','SF_EJBBSFCF','SF_EJBBCFLS','SF_EJBBCFHS','SF_FPLEFT','SF_FPTOP','SF_TKAZFFS','SF_JSATSBZ','SF_MZJKCZKZ','XT_JKTQSJ','SF_YJJGHZXJ','SF_SFCKJDDW','SF_DKZDDW','SF_ZY_FFJJ','SF_LSCFHJBRYF','SF_LSCFSFNFSRBRXM','SF_SFXMCGSXSFCF','SF_BRJKSFYXXDZ','SF_FYYFNFAZEYF','SF_YBFYDJSFLJJS','SF_YJJDSFDYPJH','SF_FYDJYSSFWK','SF_MZFPSFDYYBGRZHYE','SF_DEFAULT_HKSQKF','SF_YBBRJSSFTSDTJSFY','SF_YJJFXJZFZDXE','SF_YSXDHGHKSSFYXXG','SF_GHSYSXMSFYXWK','SF_BRNLSFXSDY','SF_SFYXXGBRBLH','SF_JZBRDTFPXZZS','SF_GHAXJYSXZLB','SF_SFQYCZPJKPJK','SF_KP_MZFPDYPLBH','SF_KP_FPZRDYMS','SF_KP_LJDLKPXTFS','XT_BRBYKFB','MZSF_FYBXJJZYXQC','SF_NNGHDTL','SF_RQDTOPLEFT','SF_RQDBOTTOMRIGHT','SF_YBJSSFYXQZHTK','SF_YBBNCZSSFZXJJZ','SF_SFYXTZZJE','SF_PRINTBLSYZDY','SF_PTBRSFAGHHJS','SF_YJJGHFYDJQDQYBZH','SF_GHFTC','SF_YJJTKQKYSPZSZ','SF_NLXDYSBSFXTLXR','SF_CKBRABLHJS','SF_FPDYGHRQ','SF_FYDJSSFBSYFYGH','SF_YJJDSFTD','SF_YJJTKDSFTD','SF_GYBRDTGHXDCS','SF_CGXESFYXQR','SF_LRSFXMSFABHPX','TJ_GRTJYXTS','SF_FZFPSFDYFYQZRQ','SF_PRINTYJJPJZDY','SF_PRINTYJJPJTKZDY','SF_FZFPDYPJXHLX','SF_HKSFKXZSQKF','XT_TJGHLB','SF_KP_CXZRSFZFYFP','SF_PRINTTJDWPJZDY','YS_SFYXPTBRTQGH','SF_MZFPSFXSFYBF','SF_XMFPSFXSYJJZE','SF_QSJDYJJZELB','SF_XMFPQDSFXSZLXM','MZ_FPGS00','SF_SFXMYBJK','IC_SFDM','SF_KP_ICKFSFDDLC','SF_SFCGHYSTHSQBZ','SF_XMYBFYDJSFKXZHLX','SF_GYZHPDBZ','SF_FPDYXS','SF_YJJPJ0','SF_XMYBZLFID','SF_MZSFYSZJHM','SF_YBSFFSGHKSBM') 114 17:13:40 SQL Prepare: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 115 17:13:40 SQL Execute: ORACLE - select * from IC_YBBRLB WHERE YBLB00='Z' 116 17:13:40 SQL Prepare: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 117 17:13:40 SQL Execute: ORACLE - select * from bm_yysfxm where sfxmid=8000000218 118 17:13:40 SQL Prepare: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 119 17:13:40 SQL Execute: ORACLE - select name00,bz0000 from xt_xtcs00 WHERE name00 in ('SF_XZXGTBLBCS','SF_FYQDBZXXNR') 120 17:13:40 SQL Prepare: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX') 121 17:13:40 SQL Execute: ORACLE - select name00,value0 from xt_xtcs00 where name00 in ('SF_YCZYBKDYBFZX','SF_SFQYPYYBJK','SF_PYYBSFSFJYYBDY','SF_XEXMHZMXBZDY','SF_GFBRXJJSSFKXFB','SF_GFBRXJJSSFKXGZFBL','SF_GFBRSFKAZFGH','SF_HFLJCYBJSDZDY','SF_FYQDBZXXNR','SF_GHSFZNCLBYYS','SF_MZPBGLSFZNCLBYYS','SF_MZHBGLSFZNCLBYYS','SF_SRYSSFXSBYYS','SF_FYDJXZCFD','SF_XZXGTBLBCS','SF_SFXYBFSJMJE','YJ_XMZJYSWSSKS','SF_FPJHJZYHKPTSFXS','SF_JMYBYFCS','SF_JMYBSCJG','SF_JMYBSCJEXZ','SF_JMYBMNJEXZ','SF_JMYBMYYSCCSXZ','SF_JMYBCXESFSF','SF_JMYBNFCS','SF_MZBRJKYJJW0','SF_FPSFXSDYRQ','SF_SFYJSGNZDQY','SF_MZBRZHWHTKMM','SF_BRZFFSXS','SF_MZRSRBBSFXSJZKYJ','SF_SFDYGEDZBB','SF_SFQYGTYBJK','SF_GTYBSFSFJYYBDY','SF_GTYBBRTKSFDYJK','SF_MZJSSFXSBFSYB','SF_BRCFQDSFXSTXM','SF_YJKTKZYXTSTK','SF_YJJCLCESFAZFJS','SF_ZCNHBRFYSFCSGYB','SF_SFQYPYJMYBJK','SF_PYJMYBSFSFJYYBDY','SF_TYDWBRSFJYJJJK','TJ_ZEJMXMID','SF_TJFYDZHSFKYTK','SF_TJPJDYSFTSXS','SF_ICKSFCYJS','SF_LEDDISPJK','SF_ZFJSSFYXQZHTK','SF_MZFPPDSFXYBR','SF_YBTKSFSYYGH','SF_HKSFSH','SF_YJJTKJESFXSFS','SF_JKRQSFGBCXGJKRQ','SF_ZFBRXB','SF_BBTJSFJQZDS','SF_ZZSRSFNYXJTC','SF_JKDYFWSFYZTYZDZ','SF_JYJJSFTSJFCG','SF_MZBKMZFSFSQKF','SF_MZRQDSFXSJFJE','SF_MZQZTKMRWZ','SF_MZQDSFXSZFJE','SF_PJJHPJSFYZSFPQF','SF_PYMTJSDZDY','SF_JKDJNLSFBT','SF_SFCLYBJKDFS','SF_SFSYSFXMZMYHJM','SF_SFCLYBJKDFS_BC','SF_JKDSFSYFR3XS','SF_SFXMJKYL','SF_MZBRQXJSSFYDK','SF_SFYJKRBBASFYHZ','SF_BRGHDJDKYJJ','SF_YBJSRBBZJYS','SF_YJJ_ZYJTDZWKSFTS','SF_FPSFDYGWYJE','SF_YBBRTSBZSFXSYJXM','ZY_XNHCSLX','SF_TSBRFYDJXMWH','ZY_XNHFZXMC','SF_YJJPZXS','SF_SFQYXFP_GZ','SF_TSBRFYDJ','SF_MZYSGZLTJ_KS','SF_MZYSGZLTJ_YS','SF_SFQYDZQB','SF_DZQBTKFS','SF_XNHBRBXSYBZHJE','SF_DZQBJKXSYE','SF_YJJFPSFSYXGS','SF_MZFYGZTFCL','SF_ZGFBJLKKHXZ','SF_YJJYEQKBSTFK','SF_FYJSQZGNSFQY','YJ_XMAPSFAKSCX','YJ_XMYXTS','XT_ZYXTGBDW','YJ_XMAPDYZDYID','YF_MZCFSFTD','YS_CFDYEKJZBZ','YJ_CXDCXMCXCF','YJ_XMCXZJTF','BQ_YJ_BQXMCXSQ','YJ_YXCXTS','YJ_YJCXD_ZDY','YS_SFTHHCCX','SF_YJCXDYMBID','SF_MZQDXJSFXSZDYH','SF_MZYJJJKSYBLH','SF_ZZJESFYXJTK','ZY_QDDYSFGJNRCDZDHH','SF_ZHWHQX') 122 17:13:40 SQL Prepare: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 123 17:13:40 SQL Execute: ORACLE - select * from BM_YBBCLX where YBYLZD>='YBYL01' and YBYLZD<='YBYL13' 124 17:13:40 SQL Prepare: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 125 17:13:40 SQL Execute: ORACLE - select VALUE0,BZ0000,to_date(substrb(VALUE0,1,8),'YYYYMMDD') SQRQ00,sysdate DTRQ00 from XT_XTCS00 where name00='SF_XNHFK' 126 17:14:04 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 127 17:14:04 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 128 17:14:04 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 129 17:14:04 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 130 17:14:04 SQL Prepare: ORACLE - select * from VW_BM_PJLXB0 where plbh00 in (0,1,2,5,7) 131 17:14:04 SQL Execute: ORACLE - select * from VW_BM_PJLXB0 where plbh00 in (0,1,2,5,7) 132 17:14:04 SQL Prepare: ORACLE - select * from XT_YYXX00 where 1=1 133 17:14:04 SQL Execute: ORACLE - select * from XT_YYXX00 where 1=1 134 17:14:17 SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 135 17:14:17 SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT' 136 17:14:17 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'3'),PYSM00) where Rownum<=1000 137 17:14:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %3% 138 17:14:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %3% 139 17:14:17 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'3'),PYSM00) where Rownum<=1000 140 17:14:17 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'30'),PYSM00) where Rownum<=1000 141 17:14:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %30% 142 17:14:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %30% 143 17:14:17 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'30'),PYSM00) where Rownum<=1000 144 17:14:17 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'302'),PYSM00) where Rownum<=1000 145 17:14:17 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %302% 146 17:14:17 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = %302% 147 17:14:17 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'302'),PYSM00) where Rownum<=1000 148 17:14:18 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'3020'),PYSM00) where Rownum<=1000 149 17:14:18 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %3020% 150 17:14:18 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = %3020% 151 17:14:18 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'3020'),PYSM00) where Rownum<=1000 152 17:14:24 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 AND XJJE00<>0 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 = :6 order by PLBH00,DYRQ00,DYSJ00 153 17:14:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 154 17:14:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 155 17:14:24 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 156 17:14:24 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 157 17:14:24 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 158 17:14:24 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 159 17:14:24 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? AND XJJE00<>0 and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 = ? order by PLBH00,DYRQ00,DYSJ00 160 17:14:25 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 =:6 order by PLBH00,DYRQ00,DYSJ00 161 17:14:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 162 17:14:25 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 163 17:14:25 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 164 17:14:25 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 165 17:14:25 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 166 17:14:25 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 167 17:14:25 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 =? order by PLBH00,DYRQ00,DYSJ00 168 17:14:43 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'3'),PYSM00) where Rownum<=1000 169 17:14:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %3% 170 17:14:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = %3% 171 17:14:43 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'3'),PYSM00) where Rownum<=1000 172 17:14:43 SQL Prepare: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like :1 or XKH000 Like :2) Order By XKH000,Instrb(PYSM00,'30'),PYSM00) where Rownum<=1000 173 17:14:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %30% 174 17:14:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = %30% 175 17:14:43 SQL Execute: ORACLE - Select * from (select ZWXM00,XKH000,PYSM00,WBSM00,BMMC00 from VW_SF_SFY000 where (PYSM00 Like ? or XKH000 Like ?) Order By XKH000,Instrb(PYSM00,'30'),PYSM00) where Rownum<=1000 176 17:14:47 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 AND XJJE00<>0 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 = :6 order by PLBH00,DYRQ00,DYSJ00 177 17:14:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 178 17:14:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 179 17:14:47 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 180 17:14:47 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 181 17:14:47 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 182 17:14:47 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈玉兰 183 17:14:47 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? AND XJJE00<>0 and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 = ? order by PLBH00,DYRQ00,DYSJ00 184 17:15:27 Log started for: SQL Navigator for Oracle 185 17:15:29 SQL Execute: select version from SYS.PRODUCT_COMPONENT_VERSION where upper(product) like '%ORACLE%' 186 17:15:29 SQL Execute: SELECT table_name, table_owner FROM all_synonyms WHERE owner = 'PUBLIC' AND synonym_name = 'QUEST_COM_TEAM_CODING' 187 17:15:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 188 17:15:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 189 17:15:30 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 190 17:15:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 191 17:15:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 192 17:15:30 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 193 17:15:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 194 17:15:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 195 17:15:30 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 196 17:15:30 SQL Execute: ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-RRRR' 197 17:15:30 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 198 17:15:30 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 199 17:15:30 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 200 17:15:31 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 201 17:15:31 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 202 17:15:31 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(instr(b.trigger_type,'BEFORE'),0,decode(instr(b.trigger_type,'AFTER'),0,decode(b.trigger_type,'INSTEAD OF',2,3),1),0) ty1,decode(instr(b.trigger_type,'STATEMENT'),0,decode(instr(b.trigger_type,'EACH ROW'),0,decode(instr(b.trigger_type,'EVENT'),0,3,2),1),0) ty2,decode(instr(b.triggering_event,'INSERT'),0,'N','Y') ev_ins,decode(instr(b.triggering_event,'UPDATE'),0,'N','Y') ev_upd,decode(instr(b.triggering_event,'DELETE'),0,'N','Y') ev_del,decode(instr(b.triggering_event,'STARTUP'),0,'N','Y') ev_startup,decode(instr(b.triggering_event,'SHUTDOWN'),0,'N','Y') ev_shutdown,decode(instr(b.triggering_event,'ERROR'),0,'N','Y') ev_error,decode(instr(b.triggering_event,'LOGON'),0,'N','Y') ev_logon,decode(instr(b.triggering_event,'LOGOFF'),0,'N','Y') ev_logoff,decode(instr(b.triggering_event,'CREATE'),0,'N','Y') ev_create,decode(instr(b.triggering_event,'ALTER'),0,'N','Y') ev_alter,decode(instr(b.triggering_event,'DROP'),0,'N','Y') ev_drop,decode(instr(b.triggering_event,'ANALYZE'),0,'N','Y') ev_analyze,decode(instr(b.triggering_event,'COMMENT'),0,'N','Y') ev_comment,decode(instr(b.triggering_event,'GRANT'),0,'N','Y') ev_grant,decode(instr(b.triggering_event,'REVOKE'),0,'N','Y') ev_revoke,decode(instr(b.triggering_event,'TRUNCATE'),0,'N','Y') ev_truncate,decode(instr(b.triggering_event,'RENAME'),0,'N','Y') ev_rename,decode(instr(b.triggering_event,' ASSOCIATE'),0,decode(substr(b.triggering_event,1,9),'ASSOCIATE','Y','N'),'Y') ev_associate,decode(instr(b.triggering_event,' AUDIT'),0,decode(substr(b.triggering_event,1,5),'AUDIT','Y','N'),'Y') ev_audit,decode(instr(b.triggering_event,' DISASSOCIATE'),0,decode(substr(b.triggering_event,1,12),'DISASSOCIATE','Y','N'),'Y') ev_disassociate,decode(instr(b.triggering_event,' NOAUDIT'),0,decode(substr(b.triggering_event,1,7),'NOAUDIT','Y','N'),'Y') ev_noaudit,decode(instr(b.triggering_event,'DDL'),0,'N','Y') ev_ddl,decode(rtrim(b.base_object_type),'TABLE',0,'VIEW',1,'SCHEMA',2,'DATABASE',3,4) base_type,b.table_owner,b.table_name,decode(b.status,'ENABLED','Y','N') enabled from user_objects a,user_triggers b where b.trigger_name like :object_name and a.object_name=b.trigger_name and a.object_type='TRIGGER' and b.trigger_name not in (select object_name from user_recyclebin where object_name=b.trigger_name) 203 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 204 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 205 17:15:32 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'N' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' and b.dropped='NO' 206 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 207 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 208 17:15:32 SQL Execute: select :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,decode(b.partitioned,'YES','Y','NO','N') partitioned,'Y' object_table,'N' external_table,decode(b.nested,'YES','Y','N') nested,decode(b.IOT_Type,'IOT',1,'IOT_OVERFLOW',2,0) IOT_Type,b.IOT_Name,b.temporary from sys.dba_objects a,sys.dba_object_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 209 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 210 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 211 17:15:32 SQL Execute: select /*+ QCO9i QCOALL */ :schema owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status,'N' partitioned,'N' object_table,'Y' external_table,'N' nested,0 IOT_Type,'' IOT_Name,'N' temporary from sys.dba_objects a,sys.dba_external_tables b where b.owner=:schema and b.table_name like :object_name and a.owner=:schema and a.object_name=b.table_name and a.object_type='TABLE' 212 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 213 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 214 17:15:32 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 215 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 216 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 217 17:15:32 SQL Execute: select referencing_names,when_clause,description,trigger_body,column_name,action_type from user_triggers where trigger_name=:object_name 218 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 219 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 220 17:15:32 SQL Execute: select a.column_name,decode(a.data_type,'VARCHAR2',0,'NUMBER',1,'FLOAT',2,'LONG',3,'VARCHAR',4,'DATE',5,'RAW',6,'LONG RAW',7,'ROWID',8,'CHAR',9,'MLSLABEL',11,'NVARCHAR2',12,'NCHAR VARYING',13,'NCHAR',14,'NCLOB',16,'CLOB',17,'BLOB',18,'BFILE',19,'CFILE',20,'UROWID',30,'BINARY_FLOAT',32,'BINARY_DOUBLE',33,decode(a.data_type_mod,'REF',15,decode(instr(a.data_type,'INTERVAL DAY'),1,29,decode(instr(a.data_type,'INTERVAL YEAR'),1,28,decode(instr(a.data_type,'TIMESTAMP'),1,decode(instr(a.data_type,'TIME ZONE'),0,26,decode(instr(a.data_type,'LOCAL TIME ZONE'),0,27,31)),decode(instr(a.data_type,'TIME'),1,decode(instr(a.data_type,'TIME ZONE'),0,24,25),decode(a.data_type_owner,null,31,21))))))) data_type,decode(a.data_type_owner,null,decode(instr(a.data_type,'INTERVAL'),1,a.data_type,decode(instr(a.data_type,'TIME'),1,a.data_type,'')),a.data_type) type_name,a.data_type_owner type_owner,a.data_length,a.data_precision,a.data_scale,a.nullable,a.column_id,a.data_default,a.num_distinct,cast(a.low_value as varchar2(500)) low_value, cast(a.high_value as varchar2(500)) high_value,a.char_length,a.owner object_owner,a.table_name object_name,b.OWNER, b.TABLE_NAME, b.COLUMN_NAME, b.ENCRYPTION_ALG, b.SALT from sys.dba_tab_columns a, sys.dba_encrypted_columns b where a.owner=:schema and a.table_name=:object_name and b.table_name(+)=a.table_name and b.column_name(+)=a.column_name and b.owner(+)=a.owner order by a.column_id 221 17:15:32 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 222 17:15:32 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 223 17:15:32 SQL Execute: select a.column_name,decode(a.column_usage,null,0,'NEW IN',1,'OLD IN',2,'NEW IN OLD IN',3,'NEW OUT',4,'NEW IN OUT',5,'NEW OUT OLD IN',6,'NEW IN OUT OLD IN',7,'PARENT IN',8,'NONE',9) column_usage,decode(a.column_list,'YES','Y','N') column_list,USER object_owner,a.trigger_name object_name from user_trigger_cols a where a.trigger_name=:object_name and a.table_owner=:parent_owner and a.table_name=:parent_name 224 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 225 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 226 17:15:33 SQL Execute: select USER owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from user_objects a where object_name like :object_name and object_type=:object_type 227 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 228 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 229 17:15:33 SQL Execute: select owner,a.object_name,a.object_id,a.created,a.last_ddl_time,decode(a.status,'VALID',0,'INVALID',1,2) status from sys.dba_objects a where a.owner like :schema and object_name like :object_name and object_type=:object_type 230 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 231 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 232 17:15:33 SQL Execute: select v.text_length,v.text,v.type_text_length,v.type_text,v.oid_text_length,v.oid_text,v.view_type_owner,v.view_type,c.comments from user_tab_comments c,user_views v where v.view_name=:object_name and c.table_name=v.view_name and c.table_type='VIEW' 233 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 234 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 235 17:15:33 SQL Execute: select constraint_name,decode(constraint_type,'C',1,'P',2,'U',3,'R',4,'V',5,'O',6,0) constraint_type,table_name,search_condition,r_owner,r_constraint_name,decode(delete_rule,'CASCADE',1,'NO ACTION',2,'SET NULL',3,0) delete_rule,decode(status,'ENABLED','Y','N') enabled,decode(deferrable,'DEFERRABLE','Y','N') deferrable,decode(deferred,'DEFERRED','Y','N') deferred,decode(validated,'VALIDATED','Y','N') validated,decode(generated,'GENERATED NAME','Y','N') generated,decode(bad,'BAD','Y','N') bad,last_change,decode(rely,'RELY','Y','N') rely from sys.dba_constraints where owner=:schema and table_name=:table_name 236 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 237 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 238 17:15:33 SQL Execute: select a.column_name,decode(a.data_type,'VARCHAR2',0,'NUMBER',1,'FLOAT',2,'LONG',3,'VARCHAR',4,'DATE',5,'RAW',6,'LONG RAW',7,'ROWID',8,'CHAR',9,'MLSLABEL',11,'NVARCHAR2',12,'NCHAR VARYING',13,'NCHAR',14,'NCLOB',16,'CLOB',17,'BLOB',18,'BFILE',19,'CFILE',20,'UROWID',30,'BINARY_FLOAT',32,'BINARY_DOUBLE',33,decode(a.data_type_mod,'REF',15,decode(instr(a.data_type,'INTERVAL DAY'),1,29,decode(instr(a.data_type,'INTERVAL YEAR'),1,28,decode(instr(a.data_type,'TIMESTAMP'),1,decode(instr(a.data_type,'TIME ZONE'),0,26,decode(instr(a.data_type,'LOCAL TIME ZONE'),0,27,31)),decode(instr(a.data_type,'TIME'),1,decode(instr(a.data_type,'TIME ZONE'),0,24,25),decode(a.data_type_owner,null,32,21))))))) data_type,decode(a.data_type_owner,null,decode(instr(a.data_type,'INTERVAL'),1,a.data_type,decode(instr(a.data_type,'TIME'),1,a.data_type,'')),a.data_type) type_name,a.data_type_owner type_owner,a.data_length,a.data_precision,a.data_scale,a.nullable,a.column_id,a.data_default,a.num_distinct,cast(a.low_value as varchar2(500)) low_value, cast(a.high_value as varchar2(500)) high_value,a.char_length,USER object_owner,a.table_name object_name,b.ENCRYPTION_ALG, b.SALT from user_tab_columns a, user_encrypted_columns b where a.table_name=:object_name and b.table_name(+)=a.table_name and b.column_name(+)=a.column_name order by a.column_id 239 17:15:33 SQL Execute: DECLARE intval BINARY_INTEGER; strval VARCHAR2(256); partyp BINARY_INTEGER; BEGIN partyp := dbms_utility.get_parameter_value('O7_DICTIONARY_ACCESSIBILITY', intval, strval); :DICT_ACCESS := partyp; END; 240 17:15:33 SQL Execute: select 'x' from session_privs where privilege='SELECT ANY DICTIONARY' 241 17:15:33 SQL Execute: select column_name,comments from user_col_comments where table_name=:object_name 242 17:15:53 SQL Prepare: select * from sf_brjfb0 where czrq00>='20120601' 243 17:15:59 SQL Prepare: select * from sf_brjfb0 where jfrq00>='20120601' 244 17:15:59 SQL Execute: select * from sf_brjfb0 where jfrq00>='20120601' 245 17:16:08 SQL Prepare: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' 246 17:16:08 SQL Execute: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' 247 17:16:29 SQL Prepare: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 248 17:16:29 SQL Execute: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 249 17:19:52 SQL Prepare: select * from xt_xtcs00 where bz0000 like '%缴款%' 250 17:19:52 SQL Execute: select * from xt_xtcs00 where bz0000 like '%缴款%' 251 17:21:04 SQL Prepare: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 252 17:21:04 SQL Execute: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 253 17:21:53 SQL Prepare: select * from xt_xtcs00 where bz0000 like '%缴款%' 254 17:21:53 SQL Execute: select * from xt_xtcs00 where bz0000 like '%缴款%' 255 17:23:02 SQL Prepare: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 256 17:23:22 SQL Execute: select * from sf_brjfb0 where jfrq00>='20120601' and zffs00<>'1' and zffsmc like '%电子%' 257 17:31:09 SQL Prepare: select * from sf_brxxb0 where brid00='140873' 258 17:31:32 SQL Execute: select * from sf_brxxb0 where brid00='140873' 259 17:33:29 Log started for: 门诊挂号收费管理系统 260 17:33:30 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 AND XJJE00<>0 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 = :6 order by PLBH00,DYRQ00,DYSJ00 261 17:33:30 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 262 17:33:30 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 263 17:33:30 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 264 17:33:30 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 265 17:33:30 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 266 17:33:30 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 267 17:33:30 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? AND XJJE00<>0 and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 = ? order by PLBH00,DYRQ00,DYSJ00 268 17:33:31 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 =:6 order by PLBH00,DYRQ00,DYSJ00 269 17:33:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 270 17:33:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 271 17:33:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 272 17:33:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 273 17:33:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 274 17:33:31 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 275 17:33:31 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 =? order by PLBH00,DYRQ00,DYSJ00 276 17:33:44 SQL Prepare: ORACLE - select JKRQ00||' '||JKSJ00 JSSJ,sfy000 from BM_JKB000 where mzbz00='0' and jkdh00 =75155 277 17:33:44 SQL Execute: ORACLE - select JKRQ00||' '||JKSJ00 JSSJ,sfy000 from BM_JKB000 where mzbz00='0' and jkdh00 =75155 278 17:33:44 SQL Prepare: ORACLE - select max(JKRQ00||' '||JKSJ00) KSSJ from BM_JKB000 where (mzbz00='0' or mzbz00='9') and pjh000<>0 and JKDH00<75155 and sfy000=151 279 17:33:44 SQL Execute: ORACLE - select max(JKRQ00||' '||JKSJ00) KSSJ from BM_JKB000 where (mzbz00='0' or mzbz00='9') and pjh000<>0 and JKDH00<75155 and sfy000=151 280 17:33:44 SQL Prepare: ORACLE - select * from VW_SF_JKB000 where JKDH00 = 75155 order by pjmc00 281 17:33:44 SQL Execute: ORACLE - select * from VW_SF_JKB000 where JKDH00 = 75155 order by pjmc00 282 17:33:45 SQL Prepare: ORACLE - select PLBH00,ltrim(PJXH00,'-') PJXH00,-(XJJE00+ZZJE00) JE0000 from sf_pjsyqk where pjzt00 = '1' and xjje00>=0 and jkdid0 =75155 283 17:33:45 SQL Execute: ORACLE - select PLBH00,ltrim(PJXH00,'-') PJXH00,-(XJJE00+ZZJE00) JE0000 from sf_pjsyqk where pjzt00 = '1' and xjje00>=0 and jkdid0 =75155 284 17:33:45 SQL Prepare: ORACLE - select sum(PJHJJE) HJ,sum(XJJE00) XJ,sum(ZZJE00) ZZ,sum(YHKJE0) YHK,sum(JZJE00) JZJE,sum(GFJE00) GFJE, sum(YBZF00) YB,sum(PJZFH0) ZFH,sum(PJZFJE) ZFJE,sum(HSZFH0) HSH,sum(HSZFJE) HSJE,sum(JKJE00) JKE ,sum(hsyhk0) hsyhk0 from VW_SF_JKB000 where JKDH00 = '75155' 285 17:33:45 SQL Execute: ORACLE - select sum(PJHJJE) HJ,sum(XJJE00) XJ,sum(ZZJE00) ZZ,sum(YHKJE0) YHK,sum(JZJE00) JZJE,sum(GFJE00) GFJE, sum(YBZF00) YB,sum(PJZFH0) ZFH,sum(PJZFJE) ZFJE,sum(HSZFH0) HSH,sum(HSZFJE) HSJE,sum(JKJE00) JKE ,sum(hsyhk0) hsyhk0 from VW_SF_JKB000 where JKDH00 = '75155' 286 17:33:45 SQL Prepare: ORACLE - select * from bm_jkb000 where pjbh00=1 and jkdh00=75155 287 17:33:45 SQL Execute: ORACLE - select * from bm_jkb000 where pjbh00=1 and jkdh00=75155 288 17:35:56 SQL Prepare: ORACLE - ROLLBACK 289 17:35:56 SQL Execute: ORACLE - ROLLBACK 290 17:35:56 SQL Data In: ORACLE - Rows affected = 0 291 17:35:58 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 AND XJJE00<>0 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 = :6 order by PLBH00,DYRQ00,DYSJ00 292 17:35:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 293 17:35:58 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 294 17:35:58 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 295 17:35:58 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 296 17:35:58 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 297 17:35:58 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 298 17:35:58 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? AND XJJE00<>0 and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 = ? order by PLBH00,DYRQ00,DYSJ00 299 17:35:59 SQL Prepare: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = :1 and DYRQ00 >= :2 and DYRQ00 <= :3 and DYRQ00||DYSJ00 >= :4 and DYRQ00||DYSJ00 <= :5 and CZYXM0 =:6 order by PLBH00,DYRQ00,DYSJ00 300 17:35:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 门诊预交金票据 301 17:35:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120601 302 17:35:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120630 303 17:35:59 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012060100:00:01 304 17:35:59 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2012063023:59:59 305 17:35:59 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 江秀玲 306 17:35:59 SQL Execute: ORACLE - select * from VW_SF_PJSYQK where 1 = 1 and PLMC00 = ? and DYRQ00 >= ? and DYRQ00 <= ? and DYRQ00||DYSJ00 >= ? and DYRQ00||DYSJ00 <= ? and CZYXM0 =? order by PLBH00,DYRQ00,DYSJ00 307 17:37:05 SQL Prepare: ORACLE - select * from sf_brjfb0 A, sf_pjsyqk B where A.PJH000 = B.PJH000 and B.JKDID0 =:1 and b.plbh00=:2 order by a.jfrq00 desc ,a.jfsj00 desc 308 17:37:05 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 75135 309 17:37:05 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 7 310 17:37:05 SQL Execute: ORACLE - select * from sf_brjfb0 A, sf_pjsyqk B where A.PJH000 = B.PJH000 and B.JKDID0 =? and b.plbh00=? order by a.jfrq00 desc ,a.jfsj00 desc 311 09:20:17 SQL Prepare: ORACLE - rollback 312 09:20:17 SQL Execute: ORACLE - rollback 313 09:20:17 SQL Data In: ORACLE - Rows affected = 0 314 09:20:17 SQL Prepare: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3122169 315 09:20:17 SQL Execute: ORACLE - Update XT_XTRZ00 Set TCRQ00=TO_CHAR(SYSDATE,'YYYYMMDD'),TCSJ00=TO_CHAR(SYSDATE,'HH24:MI:SS') where LSH000=3122169 316 09:20:17 SQL Data In: ORACLE - Rows affected = 1 317 09:20:17 SQL Prepare: ORACLE - Commit 318 09:20:17 SQL Execute: ORACLE - Commit 319 09:20:17 SQL Data In: ORACLE - Rows affected = 0 320 09:20:17 SQL Prepare: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 321 09:20:17 SQL Execute: ORACLE - update XT_SQIPDZ set ZT0000='0' where JQBH00=0 322 09:20:17 SQL Data In: ORACLE - Rows affected = 0 323 09:20:17 SQL Prepare: ORACLE - Commit 324 09:20:17 SQL Execute: ORACLE - Commit 325 09:20:17 SQL Data In: ORACLE - Rows affected = 0