1 10:16:12 Log started for: 药房管理系统 2 10:16:12 SQL Prepare: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','2','appYP_YF.exe'||'+'||'药房管理系统','78','30275' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 3 10:16:12 SQL Execute: ORACLE - Insert into sd_Hospital.XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','2','appYP_YF.exe'||'+'||'药房管理系统','78','30275' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'scott@343:83576CAB23189D39479D322843188B3A' from dual 4 10:16:12 SQL Data In: ORACLE - Rows affected = 1 5 10:16:12 SQL Prepare: ORACLE - Commit 6 10:16:12 SQL Execute: ORACLE - Commit 7 10:16:12 SQL Data In: ORACLE - Rows affected = 0 8 10:16:12 SQL Prepare: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 9 10:16:12 SQL Execute: ORACLE - Select SJKMM0,SJKKL0 from XT_DBMS00 where SYZT00='1' and Upper(SJKYH0)='SD_HOSPITAL' 10 10:16:12 SQL Prepare: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 11 10:16:12 SQL Execute: ORACLE - select YYID00 from XT_YYXX00 where YYID00='222137' 12 10:16:12 SQL Prepare: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 13 10:16:12 SQL Execute: ORACLE - select YGBH00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 14 10:16:12 SQL Prepare: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 15 10:16:12 SQL Execute: ORACLE - select * from v$session a where AUDSID=(select userenv('SESSIONID') from dual where rownum=1) 16 10:16:12 SQL Prepare: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','2','appYP_YF.exe'||'+'||'药房管理系统','116','34203' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 17 10:16:12 SQL Execute: ORACLE - Insert into XT_XTLJ00(IP0000,XTDM00,PROGRAM,SID000,serial,LJRQ00,LJSJ00,BZ0000) Select '192.168.9.99','2','appYP_YF.exe'||'+'||'药房管理系统','116','34203' ,to_char(sysdate,'YYYYMMDD'),to_char(sysdate,'HH24:MI:SS'),'sd_Hospital@343:5B2586EB59D788A88C2909EC7FB4F780' from dual 18 10:16:12 SQL Data In: ORACLE - Rows affected = 1 19 10:16:12 SQL Prepare: ORACLE - Commit 20 10:16:12 SQL Execute: ORACLE - Commit 21 10:16:12 SQL Data In: ORACLE - Rows affected = 0 22 10:16:12 SQL Prepare: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 23 10:16:12 SQL Execute: ORACLE - select DLFS00,MMXSF0 from XT_YYXT00 where XTDM00='2' 24 10:16:12 SQL Prepare: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 25 10:16:12 SQL Execute: ORACLE - select YGBH00,YHKL00,DLMM00 from BM_YGBM00 where UPPER(XKH000)='343' and CZBZ00 in ('1') 26 10:16:12 SQL Prepare: ORACLE - Select SYSDATE from Dual 27 10:16:12 SQL Execute: ORACLE - Select SYSDATE from Dual 28 10:16:12 SQL Prepare: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 29 10:16:12 SQL Execute: ORACLE - Select INSTANCE_NAME,HOST_NAME from V$INSTANCE 30 10:16:12 SQL Prepare: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 31 10:16:12 SQL Execute: ORACLE - SELECT DBBB00 FROM XT_DBMS00 WHERE ROWNUM = 1 32 10:16:12 SQL Prepare: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 33 10:16:12 SQL Execute: ORACLE - Select XTBB00,BBXH00,BMXZ00 from XT_YYXT00 where XTDM00='2' 34 10:16:13 SQL Prepare: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 35 10:16:13 SQL Execute: ORACLE - Select * from XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 36 10:16:13 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 37 10:16:13 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH From IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL','CK','JMCK') Order by SYBZ00 38 10:16:13 SQL Prepare: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 39 10:16:13 SQL Execute: ORACLE - Select a.BMMC00,a.BMBH00 from BM_BMBM00 a ,(Select BMBH00,PLXH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) b where a.FLAG00='1' and a.BMBH00=b.BMBH00 and a.BMXZ00 in ('2','3') and a.BMBH00 in (Select BMBH00 from VW_XT_YHBMQX where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) order by b.PLXH00,a.BH0000 40 10:16:13 SQL Prepare: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 41 10:16:13 SQL Execute: ORACLE - Select '0' as XTDM00 from dual where '343'='super' union Select XTDM00 from XT_ZBQX00 where XTDM00= '2' and ZBDM00 in ( Select ZBDM00 from VW_XT_YHZB00 where YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343')) union select XTDM00 from VW_XT_YHMKQX A where XTDM00='2' and YGBH00=(select YGBH00 from BM_YGBM00 where CZBZ00='1' and Upper(XKH000)='343') 42 10:16:13 SQL Prepare: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 43 10:16:13 SQL Execute: ORACLE - select ZWXM00,XKH000 from BM_YGBM00 where YGBH00=1143 44 10:16:13 SQL Prepare: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 45 10:16:13 SQL Execute: ORACLE - Select * From XT_YYXX00 where flag00 in ('0','1') order by flag00 desc 46 10:16:13 SQL Prepare: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 47 10:16:13 SQL Execute: ORACLE - Select distinct ZBJB00 from XT_XTZB00 where ZBDM00 ='00' 48 10:16:13 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 49 10:16:13 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 50 10:16:13 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 51 10:16:13 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal SID from Dual 52 10:16:13 SQL Prepare: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 53 10:16:13 SQL Execute: ORACLE - select trim(IP0000)||'#'||trim(to_char(SID000))||':'||trim(to_char(SERIAL))||'@'||trim(PROGRAM) BZ0000 from XT_XTLJ00 where (SID000,SERIAL) in (select SID,SERIAL# from V$session where AUDSID= userenv('SESSIONID')) 54 10:16:13 SQL Prepare: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3927650,1143,'wlzx','2',nvl('226861010',' '),'192.168.9.99#116:34203@appYP_YF.exe+药房管理系统',70) 55 10:16:13 SQL Execute: ORACLE - Insert into XT_XTRZ00(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,BZ0000,DLKS00) Values(3927650,1143,'wlzx','2',nvl('226861010',' '),'192.168.9.99#116:34203@appYP_YF.exe+药房管理系统',70) 56 10:16:13 SQL Data In: ORACLE - Rows affected = 1 57 10:16:13 SQL Prepare: ORACLE - Commit 58 10:16:13 SQL Execute: ORACLE - Commit 59 10:16:13 SQL Data In: ORACLE - Rows affected = 0 60 10:16:13 SQL Prepare: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 70 61 10:16:13 SQL Execute: ORACLE - select YYID00 from BM_BMBM00 where BMBH00= 70 62 10:16:13 SQL Prepare: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 63 10:16:13 SQL Execute: ORACLE - select YYBZ10,YYBZ20,YYQC00,YYJC00,YYFZ00 from XT_YYXX00 where YYID00= '222137' 64 10:16:13 SQL Prepare: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 65 10:16:13 SQL Execute: ORACLE - select SF_SF_GETYYID00() YYID00 from DUAL 66 10:16:13 SQL Prepare: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 67 10:16:13 SQL Execute: ORACLE - Select JQBH00 from XT_SQIPDZ where IP0000='192.168.9.99' 68 10:16:13 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 69 10:16:13 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('YF_CKJRZTXG','XT_SQIPDZ') 70 10:16:13 SQL Prepare: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 70 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 71 10:16:13 SQL Execute: ORACLE - select CKBH00,CKMC00,ZT0000 from BM_CKBM00 where BMBH00= 70 and FLAG00 like '%' order by decode(CKBH00,0,0,1),decode(CKBH00,0,0,1),decode(JQBH00,0,0,1),ZT0000 desc,CKBH00 72 10:16:13 SQL Prepare: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 73 10:16:13 SQL Execute: ORACLE - SELECT COUNT(1) FROM XT_YYXX00 WHERE YYID00 IN ('222137') 74 10:16:13 SQL Prepare: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'2'||',')>0 75 10:16:13 SQL Execute: ORACLE - SELECT a.* FROM XT_XTCS00 a where a.SYXT00='999' or instr(','||a.SYXT00||',' , ','||'2'||',')>0 76 10:16:15 SQL Prepare: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 77 10:16:15 SQL Execute: ORACLE - select value0 from xt_yhcs00 where ygbh00='1143' and name00='SYSTEMSKIN' 78 10:16:15 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 79 10:16:15 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 WHERE NAME00='DLXTMMXQ' 80 10:16:15 SQL Prepare: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140102' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',70,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='2') 81 10:16:15 SQL Execute: ORACLE - select count(*) from vw_ht_xttsxx where YXQ000>='20140102' and (JSKSBH is null or instr( ','||JSKSBH||',' , ',70,' )>0 ) and XXXZ00='1' and (XTDM00='-1' or XTDM00='2') 82 10:16:15 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 83 10:16:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_SFQYXTXXTSGN') 84 10:16:15 SQL Prepare: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 85 10:16:15 SQL Execute: ORACLE - SELECT * FROM XT_XTCS00 WHERE NAME00 IN('HT_XTXXTSSJJG') 86 10:16:15 SQL Prepare: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 87 10:16:15 SQL Execute: ORACLE - select OBJECT_NAME from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS<>'VALID' 88 10:16:15 SQL Prepare: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 89 10:16:15 SQL Execute: ORACLE - select Count(*) as TR_NUM from user_objects where object_type='TRIGGER' AND OBJECT_NAME LIKE 'TR_YF_%' AND STATUS='VALID' 90 10:16:15 SQL Prepare: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 91 10:16:15 SQL Execute: ORACLE - select TRIGGER_NAME from user_triggers where TRIGGER_NAME LIKE 'TR_YF_%' AND STATUS<>'ENABLED' 92 10:16:15 SQL Prepare: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=70 93 10:16:15 SQL Execute: ORACLE - SELECT BMXZ00 FROM BM_BMBM00 WHERE BMBH00=70 94 10:16:15 SQL Prepare: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 95 10:16:15 SQL Execute: ORACLE - Select SQ_XT_XTRZ00_LSH000.NextVal Val from Dual 96 10:16:15 SQL Prepare: ORACLE - select * from XT_XTCS00 97 10:16:15 SQL Execute: ORACLE - select * from XT_XTCS00 98 10:16:18 SQL Prepare: ORACLE - select * from BM_YPLB00 99 10:16:18 SQL Execute: ORACLE - select * from BM_YPLB00 100 10:16:18 SQL Prepare: ORACLE - select * from XT_YHCS00 where YGBH00=1143 101 10:16:18 SQL Execute: ORACLE - select * from XT_YHCS00 where YGBH00=1143 102 10:16:18 SQL Prepare: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 103 10:16:18 SQL Execute: ORACLE - SELECT LBMC00 FROM BM_YPLB00 where LBBH00='3' 104 10:16:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='2'))) 105 10:16:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='2' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='2'))) 106 10:16:18 SQL Prepare: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||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 107 10:16:18 SQL Execute: ORACLE - select MKDM00,MKWBMC,C.F_TYPENAME from XT_XTMK00 A,T_CTLTEMP B,T_TEMPTYPE C where A.MKDM00 like '2$%' and A.XTDM00='2' and trim(A.MKDM00)='2$'||trim(B.F_TEMPID) AND TRIM(A.XTDM00)=TRIM(B.F_SYSID) AND B.F_TEMPTYPE=C.F_TYPEID AND B.F_SYSID=C.F_SYSID AND BZ0000<>'0'ORDER BY B.F_TEMPTYPE,A.MKDM00 108 10:16:18 SQL Prepare: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 109 10:16:18 SQL Execute: ORACLE - select count(*) from XT_XTMK00 A,BB_FR3BB0 B,BB_MBLX00 C where A.XTDM00='0' and trim(A.MKDM00)='0@'||trim(B.BBID00) AND B.ZT0000='0' AND B.MBLX00=C.MBLX00 AND ((1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='0 '))) 110 10:16:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 111 10:16:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 where XTDM00='+' 112 10:16:18 SQL Prepare: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 113 10:16:18 SQL Execute: ORACLE - select MKDM00,MKNBMC,MKWBMC from XT_XTMK00 A where XTDM00='+' and (( 1143= 0) or (BZ0000<>'0' and exists(select 1 from VW_XT_YHMKQX where MKDM00=A.MKDM00 and YGBH00=1143 and XTDM00='+ '))) 114 10:16:18 SQL Prepare: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 115 10:16:18 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where NAME00 = 'SF_XTZDZXSJJG' 116 10:16:18 SQL Prepare: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=70 AND YKKCSL'0' 117 10:16:18 SQL Execute: ORACLE - SELECT 'X' FROM VW_YF_YPKCXX WHERE YFBMBH=70 AND YKKCSL'0' 118 10:16:21 SQL Prepare: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=70 and X.SFQR00='N' and T.SFQR00='Y' 119 10:16:21 SQL Execute: ORACLE - Select 'X' From YK_YPTJMX X,YK_YPTJ00 T Where X.YPTJPC=T.YPTJPC AND X.YXBMBH=70 and X.SFQR00='N' and T.SFQR00='Y' 120 10:16:29 SQL Prepare: ORACLE - SELECT FBBH00,FBMC00 FROM BM_BRFBB0 WHERE SFYX00 ='Y' 121 10:16:29 SQL Execute: ORACLE - SELECT FBBH00,FBMC00 FROM BM_BRFBB0 WHERE SFYX00 ='Y' 122 10:16:29 SQL Prepare: ORACLE - Select SQ_XT_CDJCRZ_LSH000.NextVal SID from Dual 123 10:16:29 SQL Execute: ORACLE - Select SQ_XT_CDJCRZ_LSH000.NextVal SID from Dual 124 10:16:29 SQL Prepare: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 125 10:16:29 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum=1 126 10:16:29 SQL Prepare: ORACLE - Insert into XT_CDJCRZ(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,IP0000, CDMC00,DLRQ00,DLSJ00) Values(80712,1143,'wlzx','2',nvl('226861010',' '),'192.168.9.99','门诊处方查询',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 127 10:16:29 SQL Execute: ORACLE - Insert into XT_CDJCRZ(LSH000,YGBH00,DLJSJ0,XTDM00,JCID00,IP0000, CDMC00,DLRQ00,DLSJ00) Values(80712,1143,'wlzx','2',nvl('226861010',' '),'192.168.9.99','门诊处方查询',TO_CHAR(SYSDATE,'YYYYMMDD'),TO_CHAR(SYSDATE,'HH24:MI:SS')) 128 10:16:29 SQL Data In: ORACLE - Rows affected = 1 129 10:16:29 SQL Prepare: ORACLE - Commit 130 10:16:29 SQL Execute: ORACLE - Commit 131 10:16:29 SQL Data In: ORACLE - Rows affected = 0 132 10:16:30 SQL Prepare: ORACLE - SELECT '1' chkbox,C.CFLSH0,C.GHH000,C.BRXM00,B.BRBLH0,C.XB0000,b.BRDH00,C.CSRQ00, DECODE('Y','Y',C.YSXM00,DECODE(SRRQ00,TO_CHAR(SYSDATE,'YYYYMMDD'),C.YSXM00,' ')) YSXM00, M.BMMC00 AS GHKS00,C.ZYTS00,F.FBMC00,C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH, C.DJH000,C.FYRQ00,C.FYSJ00,G.ZWXM00 AS LRY000,C.ZYDJS0, C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,H.ZWXM00 AS FYR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, (SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, ' ' ZYZDMC,' ' XYZDMC, NVL(C.CFDGS0,'5') CFDGS0,d.lbmc00,substr(SF_YF_KSSCF0(C.CFLSH0),1,1) KSSCF0, decode(SF_YF_KSSCFDPJG(C.CFLSH0),0,'合 格',1,'不合格','未点评') CFDPJG,NVL(B.BRLXDH,B.BRDH00) BRLXDH, (select nvl(a.ZWXM00,'') from BM_YGBM00 a where a.YGBH00=C.FHR000 and rownum=1) FHR000, (select count(distinct d.YPNM00) YPPZS0 from YF_MZCFMX d where c.CFLSH0=d.CFLSH0 ) YPPZS0 from BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,BM_YPLB00 d WHERE C.YFBMBH+0=70 AND C.FYRQ00>='20140102' AND C.FYRQ00<='20140102' AND C.CFZT00 like '2%' AND C.CFXZ00='0' AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00(+) AND C.BRID00=B.BRID00 AND C.BRID00=F.BRID00 AND C.GHH000=F.GHH000 AND C.FYR000=H.YGBH00(+) AND c.YPDLBH=d.lbbh00 ORDER BY C.CFZT00,C.CFLSH0 133 10:16:30 SQL Execute: ORACLE - SELECT '1' chkbox,C.CFLSH0,C.GHH000,C.BRXM00,B.BRBLH0,C.XB0000,b.BRDH00,C.CSRQ00, DECODE('Y','Y',C.YSXM00,DECODE(SRRQ00,TO_CHAR(SYSDATE,'YYYYMMDD'),C.YSXM00,' ')) YSXM00, M.BMMC00 AS GHKS00,C.ZYTS00,F.FBMC00,C.SRRQ00,C.JZRQ00,C.JZSJ00,C.CFZJE0,C.CFZT00,C.YPDLBH, C.DJH000,C.FYRQ00,C.FYSJ00,G.ZWXM00 AS LRY000,C.ZYDJS0, C.BCCFH0||TRIM(C.BZ0000) AS BZ0000,H.ZWXM00 AS FYR000, (Select ZWXM00 FROM BM_YGBM00 i Where i.YGBH00=C.PFR000) PFR000, (SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, ' ' ZYZDMC,' ' XYZDMC, NVL(C.CFDGS0,'5') CFDGS0,d.lbmc00,substr(SF_YF_KSSCF0(C.CFLSH0),1,1) KSSCF0, decode(SF_YF_KSSCFDPJG(C.CFLSH0),0,'合 格',1,'不合格','未点评') CFDPJG,NVL(B.BRLXDH,B.BRDH00) BRLXDH, (select nvl(a.ZWXM00,'') from BM_YGBM00 a where a.YGBH00=C.FHR000 and rownum=1) FHR000, (select count(distinct d.YPNM00) YPPZS0 from YF_MZCFMX d where c.CFLSH0=d.CFLSH0 ) YPPZS0 from BM_BRXXB0 B,YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G,BM_YGBM00 H,VW_YF_MZBRZH F,BM_YPLB00 d WHERE C.YFBMBH+0=70 AND C.FYRQ00>='20140102' AND C.FYRQ00<='20140102' AND C.CFZT00 like '2%' AND C.CFXZ00='0' AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00(+) AND C.BRID00=B.BRID00 AND C.BRID00=F.BRID00 AND C.GHH000=F.GHH000 AND C.FYR000=H.YGBH00(+) AND c.YPDLBH=d.lbbh00 ORDER BY C.CFZT00,C.CFLSH0 134 10:16:31 SQL Prepare: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=:1 AND SFZBY0='N' 135 10:16:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6813672 136 10:16:31 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 137 10:16:31 SQL Prepare: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=:1 AND SFZBY0='N' 138 10:16:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 6813672 139 10:16:31 SQL Execute: ORACLE - SELECT CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00, DECODE(SUBSTR(CSL000,1,1),'.','0','')||CSL000||JLDW00 AS DJL000,PCMC00,ZCXSL0, YFSMMC||YPYFMC||XMYFMC as YYFF00, YYSJ00||YYSJDW AS YYTS00,ZB0000,CXBZ00,JYSL00,YPZSL0-JYSL00 SJSL00 FROM YF_MZCFMX WHERE CFLSH0=? AND SFZBY0='N' 140 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19780802) AS NL FROM DUAL 141 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19780802) AS NL FROM DUAL 142 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19921102) AS NL FROM DUAL 143 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19921102) AS NL FROM DUAL 144 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19650815) AS NL FROM DUAL 145 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19650815) AS NL FROM DUAL 146 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19490904) AS NL FROM DUAL 147 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490904) AS NL FROM DUAL 148 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19490218) AS NL FROM DUAL 149 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490218) AS NL FROM DUAL 150 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19360509) AS NL FROM DUAL 151 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19360509) AS NL FROM DUAL 152 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19440206) AS NL FROM DUAL 153 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19440206) AS NL FROM DUAL 154 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541105) AS NL FROM DUAL 155 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541105) AS NL FROM DUAL 156 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19530131) AS NL FROM DUAL 157 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19530131) AS NL FROM DUAL 158 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 159 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 160 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541104) AS NL FROM DUAL 161 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541104) AS NL FROM DUAL 162 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19590116) AS NL FROM DUAL 163 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19590116) AS NL FROM DUAL 164 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19621119) AS NL FROM DUAL 165 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19621119) AS NL FROM DUAL 166 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19400513) AS NL FROM DUAL 167 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19400513) AS NL FROM DUAL 168 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19290319) AS NL FROM DUAL 169 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19290319) AS NL FROM DUAL 170 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20130902) AS NL FROM DUAL 171 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20130902) AS NL FROM DUAL 172 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19531231) AS NL FROM DUAL 173 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19531231) AS NL FROM DUAL 174 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19221127) AS NL FROM DUAL 175 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19221127) AS NL FROM DUAL 176 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19690103) AS NL FROM DUAL 177 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19690103) AS NL FROM DUAL 178 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541021) AS NL FROM DUAL 179 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541021) AS NL FROM DUAL 180 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19431006) AS NL FROM DUAL 181 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19431006) AS NL FROM DUAL 182 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19710102) AS NL FROM DUAL 183 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19710102) AS NL FROM DUAL 184 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20050413) AS NL FROM DUAL 185 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20050413) AS NL FROM DUAL 186 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20020310) AS NL FROM DUAL 187 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20020310) AS NL FROM DUAL 188 10:16:31 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 189 10:16:31 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 190 10:16:33 SQL Prepare: ORACLE - select count(*) counter from yf_jyxxb0 where 1=1 and cflsh0 in(select cflsh0 from yf_mzcf00 where cflsh0='6813672' and cfbdcs is null) and dyrq00='20991231' 191 10:16:33 SQL Execute: ORACLE - select count(*) counter from yf_jyxxb0 where 1=1 and cflsh0 in(select cflsh0 from yf_mzcf00 where cflsh0='6813672' and cfbdcs is null) and dyrq00='20991231' 192 10:16:33 SQL Prepare: ORACLE - Update YF_MZCF00 set CFBDCS=NVL(CFBDCS,0)+1 Where CFLSH0='6813672' 193 10:16:33 SQL Execute: ORACLE - Update YF_MZCF00 set CFBDCS=NVL(CFBDCS,0)+1 Where CFLSH0='6813672' 194 10:16:33 SQL Data In: ORACLE - Rows affected = 1 195 10:16:33 SQL Prepare: ORACLE - commit 196 10:16:33 SQL Execute: ORACLE - commit 197 10:16:33 SQL Data In: ORACLE - Rows affected = 0 198 10:16:33 SQL Prepare: ORACLE - delete from yf_cflsh0 199 10:16:33 SQL Execute: ORACLE - delete from yf_cflsh0 200 10:16:33 SQL Data In: ORACLE - Rows affected = 0 201 10:16:33 SQL Prepare: ORACLE - insert into yf_cflsh0 values('6813672') 202 10:16:33 SQL Execute: ORACLE - insert into yf_cflsh0 values('6813672') 203 10:16:33 SQL Data In: ORACLE - Rows affected = 1 204 10:16:33 SQL Prepare: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY where CFLSH0='6813672' and CFID00>0 order by CFID00 205 10:16:33 SQL Execute: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY where CFLSH0='6813672' and CFID00>0 order by CFID00 206 10:16:33 SQL Prepare: ORACLE - select CEIL(COUNT(1)/8) PAGE00,COUNT(1) COUNT0 from VW_YF_MZXYDY where CFLSH0='6813672' and CFID00>0 207 10:16:33 SQL Execute: ORACLE - select CEIL(COUNT(1)/8) PAGE00,COUNT(1) COUNT0 from VW_YF_MZXYDY where CFLSH0='6813672' and CFID00>0 208 10:16:33 SQL Prepare: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY Where (CFLSH0='-1' or CFLSH0='6813672') and CFID00<=0 ORDER BY CFID00 DESC 209 10:16:33 SQL Execute: ORACLE - select CFID00,CFMX00 from VW_YF_MZXYDY Where (CFLSH0='-1' or CFLSH0='6813672') and CFID00<=0 ORDER BY CFID00 DESC 210 10:16:33 SQL Prepare: ORACLE - select CEIL(8/8) PAGE00 from dual 211 10:16:33 SQL Execute: ORACLE - select CEIL(8/8) PAGE00 from dual 212 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19780802) AS NL FROM DUAL 213 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19780802) AS NL FROM DUAL 214 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19921102) AS NL FROM DUAL 215 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19921102) AS NL FROM DUAL 216 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19650815) AS NL FROM DUAL 217 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19650815) AS NL FROM DUAL 218 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19490904) AS NL FROM DUAL 219 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490904) AS NL FROM DUAL 220 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19490218) AS NL FROM DUAL 221 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19490218) AS NL FROM DUAL 222 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19360509) AS NL FROM DUAL 223 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19360509) AS NL FROM DUAL 224 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19440206) AS NL FROM DUAL 225 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19440206) AS NL FROM DUAL 226 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541105) AS NL FROM DUAL 227 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541105) AS NL FROM DUAL 228 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19530131) AS NL FROM DUAL 229 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19530131) AS NL FROM DUAL 230 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 231 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 232 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541104) AS NL FROM DUAL 233 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541104) AS NL FROM DUAL 234 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19590116) AS NL FROM DUAL 235 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19590116) AS NL FROM DUAL 236 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19621119) AS NL FROM DUAL 237 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19621119) AS NL FROM DUAL 238 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19400513) AS NL FROM DUAL 239 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19400513) AS NL FROM DUAL 240 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19290319) AS NL FROM DUAL 241 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19290319) AS NL FROM DUAL 242 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20130902) AS NL FROM DUAL 243 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20130902) AS NL FROM DUAL 244 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19531231) AS NL FROM DUAL 245 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19531231) AS NL FROM DUAL 246 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19221127) AS NL FROM DUAL 247 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19221127) AS NL FROM DUAL 248 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19690103) AS NL FROM DUAL 249 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19690103) AS NL FROM DUAL 250 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19541021) AS NL FROM DUAL 251 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19541021) AS NL FROM DUAL 252 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19431006) AS NL FROM DUAL 253 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19431006) AS NL FROM DUAL 254 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19710102) AS NL FROM DUAL 255 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19710102) AS NL FROM DUAL 256 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20050413) AS NL FROM DUAL 257 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20050413) AS NL FROM DUAL 258 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(20020310) AS NL FROM DUAL 259 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(20020310) AS NL FROM DUAL 260 10:19:04 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 261 10:19:04 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19600206) AS NL FROM DUAL 262 10:19:04 SQL Prepare: ORACLE - Rollback 263 10:19:04 SQL Execute: ORACLE - Rollback 264 10:19:04 SQL Data In: ORACLE - Rows affected = 0