1 18:35:13 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 2 18:35:13 SQL Execute: ORACLE - select SFDTBY from YF_BYTJ00 where ID0000 =? 3 18:35:13 SQL Execute: ORACLE - select count(*) from YF_YZYPSQ where YPQLPC IN(46313823) and nvl(ZBYBZ0,'0')='0' 4 18:35:14 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = 'CA认证接口配置' and BH0000 = 'CA_BQBYQY' 5 18:35:14 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL 6 18:35:14 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL 7 18:35:14 SQL Execute: ORACLE - select to_char(sysdate,'yyyymmdd') RQ0000,to_char(sysdate,'hh24:mi:ss') SJ0000 from dual 8 18:35:14 SQL Execute: ORACLE - Select SQ_YF_ZYFYJL_ID0000.NextVal Val from Dual 9 18:35:14 SQL Execute: ORACLE - INSERT INTO YF_ZYFYJL(ID0000,CKDH00,YZID00,YYRQ00,BQBMBH,CZY000,CZRQ00,CZSJ00,ZYID00,BZ0000,YPQLPC,DQKS00) SELECT 270010,'0',a.YZID00,a.YYRQ00,a.BQBMBH,121,'20251011','18:34:32',a.ZYID00,b.RYCWH0||'床 '||b.XM0000 BZ0000,a.YPQLPC,a.DQKS00 FROM YF_YZYPSQ a,ZY_BRXXB0 b where a.YPQLPC IN(46313823) and a.ZYID00=b.ZYID00 and nvl(a.ZBYBZ0,'0')='0' 10 18:35:15 SQL Data In: ORACLE - Rows affected = 1 11 18:35:15 SQL Execute: ORACLE - commit 12 18:35:15 SQL Data In: ORACLE - Rows affected = 0 13 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 14 18:35:15 SQL Execute: ORACLE - select nvl(max(TJRXX0),'0') from YF_BYTJ00 where SFBZLC = '5' and ID0000=? 15 18:35:15 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL 16 18:35:15 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL 17 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 18 18:35:15 SQL Execute: ORACLE - select nvl(HFRXX0,'0') from YF_BYTJ00 where SFBZLC = '4' and ID0000=? 19 18:35:15 SQL Execute: ORACLE - select to_char(sysdate,'YYYYMMDD') from DUAL 20 18:35:15 SQL Execute: ORACLE - select to_char(sysdate,'HH24:MI:SS') from DUAL 21 18:35:15 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='取药队列字典' 22 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 23 18:35:15 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=? 24 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 25 18:35:15 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=? 26 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 27 18:35:15 SQL Execute: ORACLE - select SFBZLC from YF_BYTJ00 where ID0000=? 28 18:35:15 SQL Execute: ORACLE - select SF_YF_GETYZBQ(270010,121) BQBMBH from dual 29 18:35:15 SQL Execute: ORACLE - select SF_YK_GETLSH('YF_CKDH00') CKDH00 from dual 30 18:35:15 SQL Execute: ORACLE - update YF_ZYFYJL set CKDH00='1792476' where ID0000=270010 and CZY000=121 and BQBMBH=41 31 18:35:15 SQL Data In: ORACLE - Rows affected = 1 32 18:35:15 SQL Execute: ORACLE - Commit 33 18:35:15 SQL Data In: ORACLE - Rows affected = 0 34 18:35:15 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270010 35 18:35:15 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = 121 36 18:35:15 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 41 37 18:35:15 SQL Execute: ORACLE - select distinct ZYID00,BZ0000 from YF_ZYFYJL a where a.ID0000=? and a.CZY000=? and a.BQBMBH=? 38 18:35:15 SQL Data In: ORACLE - Param = 1, Name = PBCFYID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270010 39 18:35:15 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 2082750 40 18:35:15 SQL Data In: ORACLE - Param = 3, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 41 18:35:15 SQL Data In: ORACLE - Param = 4, Name = PBQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000 42 18:35:15 SQL Data In: ORACLE - Param = 5, Name = PLYRBH0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 43 18:35:15 SQL Data In: ORACLE - Param = 6, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000 44 18:35:15 SQL Data In: ORACLE - Param = 7, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 45 18:35:15 SQL Data In: ORACLE - Param = 8, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 46 18:35:15 SQL Data In: ORACLE - Param = 9, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 18:35:15 SQL Data In: ORACLE - Param = 10, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 48 18:35:15 SQL Data In: ORACLE - Param = 11, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 49 18:35:15 SQL Data In: ORACLE - Param = 12, Name = PBYTJID, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 320 50 18:35:15 SQL Data In: ORACLE - Param = 13, Name = PSFKSFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 51 18:35:15 SQL Execute: ORACLE - BEGIN "SP_YF_BQFY00" (PBCFYID => :PBCFYID,PZYID00 => :PZYID00,PYFBMBH => :PYFBMBH,PBQBMBH => :PBQBMBH,PLYRBH0 => :PLYRBH0,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PBYTJID => :PBYTJID,PSFKSFY => :PSFKSFY); END; 52 18:35:16 SQL Data In: ORACLE - Param = 1, Name = PBCFYID, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 270010 53 18:35:16 SQL Data In: ORACLE - Param = 2, Name = PYFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 54 18:35:16 SQL Data In: ORACLE - Param = 3, Name = PBQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 41.000000 55 18:35:16 SQL Data In: ORACLE - Param = 4, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 121.000000 56 18:35:16 SQL Data In: ORACLE - Param = 5, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 30.000000 57 18:35:16 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 58 18:35:16 SQL Data In: ORACLE - Param = 7, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 59 18:35:16 SQL Data In: ORACLE - Param = 8, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 60 18:35:16 SQL Data In: ORACLE - Param = 9, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 61 18:35:16 SQL Data In: ORACLE - Param = 10, Name = Pfyckbh, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 11 62 18:35:16 SQL Data In: ORACLE - Param = 11, Name = Ptjr000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 63 18:35:16 SQL Data In: ORACLE - Param = 12, Name = PSFKSFY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 64 18:35:16 SQL Data In: ORACLE - Param = 13, Name = Pfhr000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 65 18:35:16 SQL Execute: ORACLE - BEGIN "SP_YF_BQFY00_CKQR" (PBCFYID => :PBCFYID,PYFBMBH => :PYFBMBH,PBQBMBH => :PBQBMBH,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,Pfyckbh => :Pfyckbh,Ptjr000 => :Ptjr000,PSFKSFY => :PSFKSFY,Pfhr000 => :Pfhr000); END; 66 18:35:16 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '医保追溯码配置' and BH0000 = 'YF_BQZYBYFPTS'