1 08:09:12 SQL Data In: ORACLE - Param = 1, Name = AD_BQID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 2 08:09:12 SQL Data In: ORACLE - Param = 2, Name = AD_BQBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 3 08:09:12 SQL Data In: ORACLE - Param = 3, Name = AS_TSBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 4 08:09:12 SQL Data In: ORACLE - Param = 4, Name = AS_BRXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 5 08:09:12 SQL Execute: ORACLE - BEGIN "SP_BQ_YZZXLJHLTS" (AD_BQID00 => :AD_BQID00,AD_BQBZ00 => :AD_BQBZ00,AS_TSBZ00 => :AS_TSBZ00,AS_BRXX00 => :AS_BRXX00); END; 6 08:09:12 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 7 08:09:12 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 1501681 8 08:09:12 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 9 08:09:12 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 08:09:12 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 11 08:09:12 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 12 08:09:12 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 13 08:09:12 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 14 08:09:12 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 08:09:12 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 08:09:12 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 08:09:12 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 08:09:12 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 08:09:12 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 20 08:09:12 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 08:09:12 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 22 08:09:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760885.000000 23 08:09:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/20/2015 1:0:0:0 24 08:09:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760885.000000 25 08:09:12 SQL Execute: ORACLE - SELECT Z.YZID00,DECODE(CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", YPMC00,MCSL00,JLDW00,Z.YPYFMC,Z.PCMC00, TO_CHAR(TO_DATE(QYRQ00,'YYYYMMDD'),'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TO_DATE(Z.TQRQ00,'YYYYMMDD'),'YYYY.MM.DD')"TQRQSJ", LBMC00,DECODE(CLBZ00,'0',NULL,'1',ZQS000)"TS0000", ZWXM00"KZYSXM",YZCLLB,X.PSTGBZ,x.psid00 FROM BQ_YPYZ00 Z,BQ_YPYZMX X,BM_YPLB00 L,BM_YGBM00 Y,BM_YPYF00 F WHERE Z.ZYID00=? AND Z.YZID00=X.YZID00 AND Z.YPLBBH=L.LBBH00 AND Z.KZYS00=Y.YGBH00 AND Z.YFID00=F.YFID00(+) AND Z.YZID00 IN (SELECT YZID00 FROM VW_BQ_YZZXJL_XYZX WHERE QSRQ00<=TO_CHAR((?),'YYYYMMDD') AND ZYID00=? ) AND YZCLLB IN ('正常','基数药','自备药','门诊带药','嘱托','出院带药','应急领药') order by tqrqsj,clbz00,lbmc00,yzid00 26 08:09:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760885.000000 27 08:09:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/20/2015 23:59:59:0 28 08:09:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 5/20/2015 23:59:59:0 29 08:09:12 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 30 08:09:12 SQL Execute: ORACLE - SELECT DECODE(a.CLBZ00,'0','长嘱','1','短嘱')"CLBZ00", ZLXMJC,MCSL00,a.PCMC00,TO_CHAR(QYRQSJ,'YYYY.MM.DD')"QYRQSJ", TO_CHAR(TQRQSJ,'YYYY.MM.DD')"TQRQSJ",LBMC00, DECODE(a.CLBZ00,'0',NULL,'1',TS0000)"TS0000", KZYSXM,YZCLLB,YZMXID,nvl((select sum(sfcs00*jjje00)*a.mcsl00*decode(a.ts0000,null,1,0,1,a.ts0000)*c.zqcs00 from bq_yjyzjj where yzmxid=a.yzmxid),0) JE0000 FROM VW_BQ_YJYZ00_WTZ a,bm_pc0000 c WHERE ZYID00=? AND YZLB00<>1 and ( (YZZT00='1' AND (?)-QSRQSJ>=0) OR(YZZT00='2' AND (?)-TQRQSJ>0) ) and (CJKS00 is null or CJKS00=?) and decode(a.pcid00,0,1,a.pcid00)=c.pcid00 order by tqrqsj,a.clbz00,lbmc00,yzmxid 31 08:09:12 SQL Execute: ORACLE - select SQ_BM_ZYTEMP_TQID.NEXTVAL from dual 32 08:09:13 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 33 08:09:13 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760885.000000 34 08:09:13 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 35 08:09:13 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 36 08:09:13 SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 08:09:13 SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 38 08:09:13 SQL Data In: ORACLE - Param = 7, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/20/2015 0:0:0:0 39 08:09:13 SQL Data In: ORACLE - Param = 8, Name = PTQID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 85736 40 08:09:13 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00,PTQID00 => :PTQID00); END; 41 08:09:14 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000 42 08:09:14 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760885.000000 43 08:09:14 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 44 08:09:14 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 45 08:09:14 SQL Data In: ORACLE - Param = 5, Name = PLBBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 08:09:14 SQL Data In: ORACLE - Param = 6, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 5/20/2015 0:0:0:0 47 08:09:14 SQL Data In: ORACLE - Param = 7, Name = PBCTQID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 08:09:14 SQL Data In: ORACLE - Param = 8, Name = PCJKS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 507.000000 49 08:09:14 SQL Data In: ORACLE - Param = 9, Name = PTQID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 85736 50 08:09:14 SQL Execute: ORACLE - BEGIN "SP_BQ_YJYZZX_NOHL" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PLBBH00 => :PLBBH00,PZXRQ00 => :PZXRQ00,PBCTQID => :PBCTQID,PCJKS00 => :PCJKS00,PTQID00 => :PTQID00); END; 51 08:09:36 SQL Error: ORACLE - ORA-02055: 分布式更新操作失效; 要求回退 ORA-20002: ORA-20020: ORA-20002: ORA-20001: ORA-01400: 无法将 NULL 插入 ("SD_ZY"."SS_YWMX00"."SSXMJC")！* ORA-06512: 在 "SD_HOSPITAL.TR_BQ_YJYZ00_AFTERUPD_SS", l ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YJYZZX_NOHL", line 168 ORA-06512: 在 line 1 52 08:09:36 SQL Error: ORACLE - Unmapped SQL Error Code: 2055