1 15:24:15 Log started for: SQL Navigator for Oracle 2 15:25:17 Log started for: Yjsystem 3 15:25:25 SQL Execute: ORACLE - select yyqc00 from xt_yyxx00 4 15:25:25 SQL Execute: ORACLE - select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00, b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000, b.csrq00,b.brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid, b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00, b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0, b.zxrq00,b.brybmc,b.zxsj00,b.cxsl00,b.txm000,b.SYLSH0 from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and yjdjh0=1 5 15:25:25 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 15:25:25 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 7 15:25:25 SQL Execute: ORACLE - select value0 from xt_xtcs00 where name00='YJ_YZXSFTXYCXJL' 8 15:25:25 SQL Execute: ORACLE - select value0 from xt_xtcs00 where (name00='YJ_QZZXQR' and value0='Y') and exists (select 1 from XT_XTCS00 where NAME00='YJ_ZYZLDYXQF' and trim(Value0)='Y') 9 15:25:25 SQL Execute: ORACLE - SELECT VALUE0 FROM XT_XTCS00 WHERE NAME00='YJ_TMCF_TMHZ' 10 15:25:25 SQL Execute: ORACLE - select 1 from dual where 50 in (-1) 11 15:25:25 SQL Execute: ORACLE - select VALUE0 from XT_XTCS00 where name00='YJ_JCDZZGD' 12 15:25:25 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 13 15:25:25 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 14 15:25:25 SQL Execute: ORACLE - select bmbh00,bmmc00 from bm_bmbm00 where bmxz00='9' and flag00='1' 15 15:25:25 SQL Execute: ORACLE - select count(*) from xt_zldczl where rownum=1 16 15:25:42 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 17 15:25:42 SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1 18 15:25:42 SQL Data In: ORACLE - Param = 3, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 78379 19 15:25:42 SQL Data In: ORACLE - Param = 4, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 20 15:25:42 SQL Data In: ORACLE - Param = 5, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 15:25:42 SQL Data In: ORACLE - Param = 6, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 15:25:42 SQL Data In: ORACLE - Param = 7, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 23 15:25:42 SQL Data In: ORACLE - Param = 8, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 24 15:25:42 SQL Data In: ORACLE - Param = 9, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 25 15:25:42 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 26 15:25:42 SQL Data In: ORACLE - Param = 11, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 27 15:25:42 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 28 15:25:42 SQL Data In: ORACLE - Param = 13, Name = PKSMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 29 15:25:42 SQL Data In: ORACLE - Param = 14, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 30 15:25:42 SQL Data In: ORACLE - Param = 15, Name = PMZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 31 15:25:42 SQL Data In: ORACLE - Param = 16, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 32 15:25:42 SQL Data In: ORACLE - Param = 17, Name = PBRNL00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 33 15:25:42 SQL Execute: ORACLE - BEGIN "SP_YJ_GETBRXX" (PBRID00 => :PBRID00,PMZZYBZ => :PMZZYBZ,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PYBLB00 => :PYBLB00,PFBBH00 => :PFBBH00,PFBMC00 => :PFBMC00,PYBBRLB => :PYBBRLB,PYBMC00 => :PYBMC00,PKSMC00 => :PKSMC00,PCSRQ00 => :PCSRQ00,PMZYE00 => :PMZYE00,PZYYE00 => :PZYYE00,PBRNL00 => :PBRNL00); END; 34 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 577118.000000 35 15:25:42 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 36 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 15:25:42 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 38 15:25:42 SQL Execute: ORACLE - SELECT A.*,'1' PCMC00 FROM YF_MZCFMX A WHERE CFID00=1 39 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 15:25:42 SQL Execute: ORACLE - select * from BQ_YPYZMX where YZID00=? 41 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 98.000000 42 15:25:42 SQL Execute: ORACLE - select * from BQ_YPYZMX where YZMXID=? 43 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8524272.000000 44 15:25:42 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 45 15:25:42 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 46 15:25:42 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 47 15:25:42 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = ,50, 48 15:25:42 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140225 49 15:25:42 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20140304 50 15:25:42 SQL Execute: ORACLE - select rownum xh0000,g.* from ( Select b.xmzt00,b.zlxmid,b.mzzybz,b.yzcfid,b.dcbz00,b.brid00,b.yjdjh0,b.yjfzh0,b.zyhghh,b.brxm00,b.yexm00,b.zlxmjc,b.xb0000,b.csrq00,substr(b.brnl00,1,100) brnl00,b.lrxm00,b.kdsj00,b.zyghid,c.lbbh00,c.zyzbid,b.kdysxm,b.kdksmc,b.kdrq00,b.jzbz00,b.bwmc00,b.bz0000,b.zdmc00,b.sl0000,b.ZXSL00,b.ZJE000,b.yjlrbz,b.kdbq00,b.cxdjh0,b.zxrxm0,b.zxrq00,b.zxsj00,b.brybmc,b.SM0000,ZLDCCF,b.CXSL00,b.txm000,b.FBBH00,b.CH0000,b.yjksbh,(select bmmc00 from bm_bmbm00 where bmbh00=b.YJKSBH) YJKSMC from vw_yj_yw0000 b,bm_zlzd00 c where c.zlxmid=b.zlxmid and b.zlxmjc<>'医技科室费用退费' and xmzt00 in ('0','1','2') and b.mzzybz='1' and brid00=? and (YJKSBH=? or ( (((b.Zlxmid,b.kdksbh) in (Select Zlxmid,SQXMKS from vw_XT_xmfwfx where jsxmks=?)) or ( b.ZLXMID in (Select ZLXMID from VW_YS_YJZXKS where BMBH00=?) )) and ( (',0,'=',0,') or (instr(',0,',? )>0) ) ) ) and kdrq00 between ? and ? and b.SL0000-nvl(b.CXSL00,0)-b.ZXSL00>0 order by brid00,zyhghh,zyzbid,yzcfid,kdrq00,zlxmid) g 51 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730196.000000 52 15:25:42 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 53 15:25:42 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730196.000000 54 15:25:42 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 55 15:25:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 56 15:25:44 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 57 15:25:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 58 15:25:44 SQL Execute: ORACLE - Select J.id0000,yjdjh0,yjfzh0,J.sfxmid,J.sfxx00,j.sfcs00,J.GDBZ00,J.FJFYBZ,J.jjje00,J.gfje00, J.zfje00,J.sfsx00,J.ybbz00,trim(S.XMMC00) XMMC00,j.jzje00,s.sfje00,sl0000,j.mxid00,j.gjbm00,j.sflb00,j.zfbl00 from yj_ywjj00 J,BM_YYSFXM S WHERE J.SFXMID=S.SFXMID and YjFzh0=? 59 15:25:44 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 60 15:25:44 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 61 15:25:44 SQL Execute: ORACLE - select nvl(sum(cfzje0),0) vzje001 from yf_zycf00 where zyid00=577118 and ((cflsh0='') or Instr(','||''||',',','||trim(cflsh0)||',')>0) and SFKSLY='Y' and cfzt00 in ('0','4') 62 15:25:44 SQL Execute: ORACLE - select a.DAXXID,a.SBMC00 from VW_SB_SYKS00_YJ a,BM_ZLZD00 b,XT_KSZXXM c where b.ZLXMID=c.ZLXMID and a.DAXXID=c.DAXXID and c.ZXKSBH= 50 and c.ZLXMID= 6976 63 15:25:46 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 64 15:25:46 SQL Execute: ORACLE - select fbzxbz from yj_yw0000 where yjdjh0=? 65 15:25:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 66 15:25:48 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000,zxrxm0,zxrq00,zxsj00,sl0000, (select SBMC00 from SB_DA0000 where DAXXID=a.DAXXID and rownum=1) SBMC00 from yj_ywmx00 a where yjdjh0=? 67 15:25:48 SQL Data In: ORACLE - Param = 1, Name = PYJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 9730198.000000 68 15:25:48 SQL Data In: ORACLE - Param = 2, Name = PZLXMID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 69 15:25:48 SQL Data In: ORACLE - Param = 3, Name = PZXSL00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 70 15:25:48 SQL Data In: ORACLE - Param = 4, Name = PZXMBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 71 15:25:48 SQL Data In: ORACLE - Param = 5, Name = PXKH000, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 0218 72 15:25:48 SQL Data In: ORACLE - Param = 6, Name = PZXKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 50.000000 73 15:25:48 SQL Execute: ORACLE - BEGIN "SP_YJ_YWZX00" (PYJDJH0 => :PYJDJH0,PZLXMID => :PZLXMID,PZXSL00 => :PZXSL00,PZXMBZ => :PZXMBZ,PXKH000 => :PXKH000,PZXKS00 => :PZXKS00); END; 74 15:25:48 SQL Error: ORACLE - ORA-20020: ORA-20080: ORA-20010: 不能修改已收费项目的收费单据号！！* ORA-06512: 在 "SD_HOSPITAL.TR_YJ_YW0000_PROTECT", line 34 ORA- ORA-06512: 在 "SD_HOSPITAL.SP_YJ_YWZX00", line 596 ORA-06512: 在 line 1 75 15:25:48 SQL Error: ORACLE - Unmapped SQL Error Code: 20020