1 11:03:20 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('感') wbsm00,sf_yj_Getpysm('感') pysm00 from dual where rownum=1 2 11:03:20 SQL Execute: ORACLE - Select sf_yj_GetWbsm('感') wbsm00,sf_yj_Getpysm('感') pysm00 from dual where rownum=1 3 11:03:20 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('感冒') wbsm00,sf_yj_Getpysm('感冒') pysm00 from dual where rownum=1 4 11:03:20 SQL Execute: ORACLE - Select sf_yj_GetWbsm('感冒') wbsm00,sf_yj_Getpysm('感冒') pysm00 from dual where rownum=1 5 11:03:26 SQL Prepare: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1 6 11:03:26 SQL Execute: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1 7 11:03:26 SQL Prepare: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 301,mblbid,'感冒',952,'gm','dj','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0)) 8 11:03:26 SQL Execute: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 301,mblbid,'感冒',952,'gm','dj','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0)) 9 11:03:26 SQL Data In: ORACLE - Rows affected = 1 10 11:03:26 SQL Prepare: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END; 11 11:03:26 SQL Data In: ORACLE - Param = 1, Name = PYZID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5230847 12 11:03:26 SQL Data In: ORACLE - Param = 2, Name = PMBID00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 301 13 11:03:26 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 952.000000 14 11:03:26 SQL Data In: ORACLE - Param = 4, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 15 11:03:26 SQL Data In: ORACLE - Param = 5, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 16 11:03:26 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 17 11:03:26 SQL Execute: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END; 18 11:03:26 SQL Error: ORACLE - ORA-20002: ORA-20106: 药品: 顺铂 为每次取整药品,总量数据必须为整数！ ORA-06512: 在"SD_HOSPITAL.TR_XT_YPMBMX_BINS_UPD_DEL", line 54 ORA-04088: 触发器 'SD_HOSPITAL.TR_XT_YPMBMX_BINS_UPD_DEL' 执行过程中出错！*SP_ZS_SAVEMB('5230847','' ORA-06512: 在"SD_HOSPITAL.SP_ZS_SAVEMB", line 120 ORA-06512: 在line 1 19 11:03:26 SQL Error: ORACLE - Unmapped SQL Error Code: 20002 20 11:04:58 SQL Prepare: ORACLE - rollback 21 11:04:58 SQL Execute: ORACLE - rollback 22 11:04:58 SQL Data In: ORACLE - Rows affected = 0 23 11:05:33 SQL Prepare: ORACLE - select SF_YS_CKBG00('0',794688,'1',0,5230847) from dual 24 11:05:33 SQL Execute: ORACLE - select SF_YS_CKBG00('0',794688,'1',0,5230847) from dual 25 11:05:34 SQL Prepare: ORACLE - select YPLBBH from BQ_YPYZ00 where YZID00=5230847 26 11:05:34 SQL Execute: ORACLE - select YPLBBH from BQ_YPYZ00 where YZID00=5230847 27 11:05:34 SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00' 28 11:05:34 SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=952 and mbgs00='0' and mblbbh='00' 29 11:05:34 SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbks=66 and mbgs00='1' and mblbbh='01' 30 11:05:34 SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbks=66 and mbgs00='1' and mblbbh='01' 31 11:05:34 SQL Prepare: ORACLE - select count(*) from xt_yzmblb where symbys=0 and symbks=0 and mbgs00='2' and mblbbh='02' 32 11:05:34 SQL Execute: ORACLE - select count(*) from xt_yzmblb where symbys=0 and symbks=0 and mbgs00='2' and mblbbh='02' 33 11:05:34 SQL Prepare: ORACLE - Select * from xt_yzmblb where (symbys=952 and mbgs00='0') or (symbks=66 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') 34 11:05:34 SQL Execute: ORACLE - Select * from xt_yzmblb where (symbys=952 and mbgs00='0') or (symbks=66 and mbgs00='1') or (symbys=0 and symbks=0 and mbgs00='2') 35 11:05:34 SQL Prepare: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 36 11:05:34 SQL Execute: ORACLE - select ypyfmc,yfid00 from vw_zs_cyzjyf 37 11:05:34 SQL Prepare: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))) order by mbmc00 38 11:05:34 SQL Execute: ORACLE - Select * from vw_xt_yzmb00 where mblbid =(select mblbid from xt_yzmblb where mblbbh='00'and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0))) order by mbmc00 39 11:05:34 SQL Prepare: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=:1 and yplb00='0' order by zbbh00,znxh00 40 11:05:34 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000 41 11:05:34 SQL Execute: ORACLE - select m.mxid00,m.mbid00,m.ypnm00,m.yfid00,m.pcid00, m.jl0000,m.ypzsl0,m.zldw00,m.yysj00,m.yysjdw,m.zb0000, y.ypmc00,f.ypyfmc,p.pcmc00, m.ypzsl0/decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000)zsl000, decode(zldw00,y.zyfydw,y.z2j000,y.mzfydw,y.m2j000,k2j000) zhl000, y.ypgg00,y.jldw00,y.z2j000,y.m2j000,y.k2j000,y.zyfydw,y.mzfydw, y.kcdw00,p.zqcs00,yyzf00,znxh00,zbbh00 from xt_ypmbmx m,vw_zs_yd0000_all y,bm_pc0000 p,bm_ypyf00 f where m.ypnm00=y.ypnm00 and m.pcid00=p.pcid00(+) and m.yfid00=f.yfid00(+) and mbid00=? and yplb00='0' order by zbbh00,znxh00 42 11:05:59 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('感') wbsm00,sf_yj_Getpysm('感') pysm00 from dual where rownum=1 43 11:05:59 SQL Execute: ORACLE - Select sf_yj_GetWbsm('感') wbsm00,sf_yj_Getpysm('感') pysm00 from dual where rownum=1 44 11:05:59 SQL Prepare: ORACLE - Select sf_yj_GetWbsm('感冒') wbsm00,sf_yj_Getpysm('感冒') pysm00 from dual where rownum=1 45 11:05:59 SQL Execute: ORACLE - Select sf_yj_GetWbsm('感冒') wbsm00,sf_yj_Getpysm('感冒') pysm00 from dual where rownum=1 46 11:06:03 SQL Prepare: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1 47 11:06:03 SQL Execute: ORACLE - select SQ_XT_YZMB00_MBID00.nextval from dual where rownum=1 48 11:06:03 SQL Prepare: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 302,mblbid,'感冒',952,'gm','dj','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0)) 49 11:06:03 SQL Execute: ORACLE - insert into XT_yzmb00 (MBID00, MBLBID, MBMC00, CZY000, PYSM00, WBSM00, YXBZ00,BZ0000) select 302,mblbid,'感冒',952,'gm','dj','1','' from xt_yzmblb where mblbbh='00' and ((symbys=952) or (symbks=66) or (symbys=0 and symbks=0)) 50 11:06:03 SQL Data In: ORACLE - Rows affected = 1 51 11:06:03 SQL Prepare: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END; 52 11:06:03 SQL Data In: ORACLE - Param = 1, Name = PYZID00, Type = fldZSTRING, Precision = 7, Scale = 0, Data = 5230847 53 11:06:03 SQL Data In: ORACLE - Param = 2, Name = PMBID00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 302 54 11:06:03 SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 952.000000 55 11:06:03 SQL Data In: ORACLE - Param = 4, Name = PZXJG00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 56 11:06:03 SQL Data In: ORACLE - Param = 5, Name = PZXBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 57 11:06:03 SQL Data In: ORACLE - Param = 6, Name = PCOMMIT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 58 11:06:03 SQL Execute: ORACLE - BEGIN "SP_ZS_SAVEMB" (PYZID00 => :PYZID00,PMBID00 => :PMBID00,PCZY000 => :PCZY000,PZXJG00 => :PZXJG00,PZXBZ00 => :PZXBZ00,PCOMMIT => :PCOMMIT); END; 59 11:06:03 SQL Error: ORACLE - ORA-20002: ORA-20106: 药品: 顺铂 为每次取整药品,总量数据必须为整数！ ORA-06512: 在"SD_HOSPITAL.TR_XT_YPMBMX_BINS_UPD_DEL", line 54 ORA-04088: 触发器 'SD_HOSPITAL.TR_XT_YPMBMX_BINS_UPD_DEL' 执行过程中出错！*SP_ZS_SAVEMB('5230847','' ORA-06512: 在"SD_HOSPITAL.SP_ZS_SAVEMB", line 120 ORA-06512: 在line 1 60 11:06:03 SQL Error: ORACLE - Unmapped SQL Error Code: 20002