1 20:36:23 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'E') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',22,')> 0) and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '22') AND (INSTR (',' || a.jsksbh || ',',',22,') > 0 or a.jsksbh is null) 2 20:36:24 SQL Execute: ORACLE - select count(1) from WZ_WZXX00 where SFXMID=8000040399 and GZHC00='Y' and SFYX00='Y' 3 20:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000040399 4 20:36:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2364 5 20:36:24 SQL Execute: ORACLE - select SF_YJ_SPDHCJFPD(?,?) as RES from dual 6 20:36:24 SQL Error: ORACLE - ORA-00904: "SF_YJ_SPDHCJFPD": 标识符无效 7 20:36:24 SQL Data In: ORACLE - Rows affected = 0 8 20:36:24 SQL Execute: ORACLE - select SQ_YJ_YW0000_YJDJH0.NEXTVAL from DUAL 9 20:36:24 SQL Execute: ORACLE - select SQ_YJ_YWJJ00_ID0000.NEXTVAL from DUAL 10 20:36:24 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'YYYYMMDD') OraSysDate FROM DUAL 11 20:36:24 SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'HH24:MI:SS') OraSysDate FROM DUAL 12 20:36:24 SQL Execute: ORACLE - select count(1) from WZ_WZXX00 where SFXMID=8000044725 and GZHC00='Y' and SFYX00='Y' 13 20:36:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 10, Scale = 0, Data = 8000044725 14 20:36:24 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2364 15 20:36:24 SQL Execute: ORACLE - select SF_YJ_SPDHCJFPD(?,?) as RES from dual 16 20:36:24 SQL Error: ORACLE - ORA-00904: "SF_YJ_SPDHCJFPD": 标识符无效 17 20:36:24 SQL Data In: ORACLE - Rows affected = 0 18 20:36:24 SQL Execute: ORACLE - select SF_SS_CHECKBRYE('805975') MSG from dual 19 20:36:24 SQL Execute: ORACLE - delete SS_SSYJD0 where YJDJH0 in (32582820) 20 20:36:24 SQL Data In: ORACLE - Rows affected = 1 21 20:36:24 SQL Execute: ORACLE - delete YJ_YWJJ00 where YJDJH0 in (32582820) 22 20:36:24 SQL Data In: ORACLE - Rows affected = 1 23 20:36:24 SQL Execute: ORACLE - delete YJ_YW0000 where YJDJH0 in (32582820) 24 20:36:24 SQL Data In: ORACLE - Rows affected = 1 25 20:36:24 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0,SL0000,ZYGHID,MZZYBZ,ZLXMID,YJKSBH,KDYS00,KDKSBH,KDRQ00,KDSJ00,LRXM00,XMZT00,YJLRBZ,KDBQ00,BH0000,MC0000,ZXDCBZ,YSZID0,YEXM00,CZBZ00) values('32582820','1','805975','1','0','22','1231','2364','20240423','09:41:59','管理员', '1','S','3113','','','2','37','','') 26 20:36:24 SQL Data In: ORACLE - Rows affected = 1 27 20:36:24 SQL Execute: ORACLE - insert into SS_SSYJD0(SSDH00,YJDJH0,SSMZBZ) values('75598','32582820','0') 28 20:36:24 SQL Data In: ORACLE - Rows affected = 1 29 20:36:24 SQL Execute: ORACLE - insert into YJ_YWJJ00(ID0000,YJDJH0,SFXMID,SL0000,SFCS00,JJJE00,GJBM00,SFXX00,SFSX00,TXM000,XKZH00,SFLB00,SCPH00,WZDWM0,GZJLH0,ZTM000,CTM000,BSM000,HCID00,HCDJ00,HCPH00,HCGYS0,HCYXQ0,HCZCZH,ZFFSBZ) values('49128907','32582820','8000040399','1','1','30','910180','0','32.4','','','2','','','','','','','',to_number(nvl('0','0')),nvl('',''), nvl('',''),nvl('',''), nvl('','') ,nvl('N','') ) 30 20:36:24 SQL Data In: ORACLE - Rows affected = 1 31 20:36:24 SQL Execute: ORACLE - select count(*) COU from YJ_YWJJ00 where YJDJH0=32582820 32 20:36:24 SQL Execute: ORACLE - insert into YJ_YW0000(YJDJH0,SL0000,ZYGHID,MZZYBZ,ZLXMID,YJKSBH,KDYS00,KDKSBH,KDRQ00,KDSJ00,LRXM00,XMZT00,YJLRBZ,KDBQ00,BH0000,MC0000,ZXDCBZ,YSZID0,YEXM00,CZBZ00) values('32582821','1','805975','1','15007','22','1231','2364','20240423','09:42:31','管理员', '1','S','3113','','','2','37','','') 33 20:36:24 SQL Data In: ORACLE - Rows affected = 1 34 20:36:24 SQL Execute: ORACLE - insert into SS_SSYJD0(SSDH00,YJDJH0,SSMZBZ) values('75598','32582821','0') 35 20:36:24 SQL Data In: ORACLE - Rows affected = 1 36 20:36:24 SQL Execute: ORACLE - insert into YJ_YWJJ00(ID0000,YJDJH0,SFXMID,SL0000,SFCS00,JJJE00,GJBM00,SFXX00,SFSX00,TXM000,XKZH00,SFLB00,SCPH00,WZDWM0,GZJLH0,ZTM000,CTM000,BSM000,HCID00,HCDJ00,HCPH00,HCGYS0,HCYXQ0,HCZCZH,ZFFSBZ) values('49128908','32582821','8000044725','1','1','8','950019','0','8','','','2','','','','','','','',to_number(nvl('','0')),nvl('',''), nvl('',''),nvl('',''), nvl('','') ,nvl('N','') ) 37 20:36:24 SQL Data In: ORACLE - Rows affected = 1 38 20:36:24 SQL Execute: ORACLE - select count(*) COU from YJ_YWJJ00 where YJDJH0=32582821 39 20:36:24 SQL Execute: ORACLE - select SF_SS_JSXMJY(805975,'1',75598,22,'32582820,32582821','0') MSG000 from dual 40 20:36:24 SQL Execute: ORACLE - select * from XT_YYXX00 41 20:36:24 SQL Execute: ORACLE - select trim(BZ0000) BZ0000,MC0000 from BM_TYZD00 a where ZDMC00=+'URL地址' and BZ0000='' 42 20:36:24 SQL Execute: ORACLE - select b.MXNODE,b.JKCJMC,b.DJXS00,a.* from BM_TYJKBM a,BM_TYJKMX b where b.JKCJMC='耗材保存' and a.JKBH00=b.JKBH00 and b.JKCJLB='0' and b.SFQY00='1' and a.SFQY00='1' and (a.QYKS00 is null or instr(','||a.QYKS00||',',',22,')>0) order by nvl(a.QYKS00,'0') desc 43 20:36:24 SQL Execute: ORACLE - Commit 44 20:36:24 SQL Data In: ORACLE - Rows affected = 0 45 20:36:24 SQL Execute: ORACLE - select BRID00 from ZY_BRXXB0 where ZYH000 = '412817' 46 20:36:24 SQL Execute: ORACLE - select ZYID00,DBZBM0,DBZMC0 from zy_brxxb0 where brid00 = 1624141 and substr(BRZT00,1,1) in('2','3') 47 20:36:24 SQL Execute: ORACLE - select SF_ZY_GETDBZXX(805975, 3) DBZDE0 from dual 48 20:36:24 SQL Execute: ORACLE - select SSMC00,SSBH00,BWMC00 from VW_SS_YWMX00 where SSDH00='75598' order by SFZSS0 49 20:36:24 SQL Execute: ORACLE - select B.*,C.SSDH00 SSDH00 from VW_SS_YWJJ00 B,SS_SSYJD0 C where B.YJDJH0=C.YJDJH0 and C.SSDH00='75598' and C.SSMZBZ='0' and B.YJKSBH=22 and B.ZYGHID=805975 and (not exists (select 'y' from YJ_YW0000 A where A.CXDJH0=B.YJDJH0)) and ((B.CXDJH0=0) or (B.CXDJH0 is null)) and B.XMZT00 in ('0','1') order by B.YJDJH0 50 20:48:30 Log started for: SQL Navigator for Oracle 51 20:57:19 Log started for: 手术麻醉管理系统