1 17:00:20 SQL Execute: ORACLE - select * from bm_brxxb0 where brid00=2850214 2 17:00:20 SQL Execute: ORACLE - select sum(A.HJJE00) HJJE00,sum(A.ZFJE00) ZFJE00,sum(A.JZJE00) JZJE00,sum(A.GFJE00) GFJE00 from sf_fymx00 A,bm_yysfxm B,bm_fpxm00 C,sf_brfy00 D where A.XMBH00 = B.SFXMID and B.MZFPID = C.FPXMID and A.DJH000 = D.DJH000 and D.JZDH00+0 = 0 and a.xmbh00+0 <> 8000035602 and D.BRID00 = 2850214 and D.JFLBID = 1 and D.CZRQ00>= '20170508' and D.CZRQ00<= '20170512' and not exists ( select 1 from VW_SF_YBTZBZ e where e.brid00=d.brid00 and e.djh000=d.djh000 and e.tsbzbh<>'' ) 3 17:00:20 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 4 17:00:20 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170508 5 17:00:20 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170512 6 17:00:20 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2850214.000000 7 17:00:20 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 8 17:00:20 SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 9 17:00:20 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 17:00:20 SQL Execute: ORACLE - select SF_SF_YPTSBZ(?,?,?,?,?,?,?)tsxx00 from dual 11 17:00:22 SQL Execute: ORACLE - Select * from BM_KPYHDY where SYZT00='1' and Upper(XKH000)='5028' 12 17:00:22 SQL Data In: ORACLE - Param = 1, Name = AS_YBDJH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 13 17:00:22 SQL Data In: ORACLE - Param = 2, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170508 14 17:00:22 SQL Data In: ORACLE - Param = 3, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170512 15 17:00:22 SQL Data In: ORACLE - Param = 4, Name = AS_GHH000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 16 17:00:22 SQL Data In: ORACLE - Param = 5, Name = AS_ICKH00, Type = fldZSTRING, Precision = 13, Scale = 0, Data = NPYBH37894320 17 17:00:22 SQL Data In: ORACLE - Param = 6, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2850214.000000 18 17:00:22 SQL Data In: ORACLE - Param = 7, Name = AD_JFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 19 17:00:22 SQL Data In: ORACLE - Param = 8, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 肖启乐 20 17:00:22 SQL Data In: ORACLE - Param = 9, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女 21 17:00:22 SQL Data In: ORACLE - Param = 10, Name = AD_BRFB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 22 17:00:22 SQL Data In: ORACLE - Param = 11, Name = AD_BRZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 23 17:00:22 SQL Data In: ORACLE - Param = 12, Name = AD_JZJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 24 17:00:22 SQL Data In: ORACLE - Param = 13, Name = AD_GFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 25 17:00:22 SQL Data In: ORACLE - Param = 14, Name = AD_HJJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 26 17:00:22 SQL Data In: ORACLE - Param = 15, Name = AD_JMJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 27 17:00:22 SQL Data In: ORACLE - Param = 16, Name = AS_ZPZH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 28 17:00:22 SQL Data In: ORACLE - Param = 17, Name = AD_GRZHZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 29 17:00:22 SQL Data In: ORACLE - Param = 18, Name = AD_TCJJZF, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 30 17:00:22 SQL Data In: ORACLE - Param = 19, Name = AD_ZFJE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 8.000000 31 17:00:22 SQL Data In: ORACLE - Param = 20, Name = AD_JZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760.000000 32 17:00:22 SQL Data In: ORACLE - Param = 21, Name = AS_JZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 付建平 33 17:00:22 SQL Data In: ORACLE - Param = 22, Name = AD_JZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1104.000000 34 17:00:22 SQL Data In: ORACLE - Param = 23, Name = AS_JMYY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 35 17:00:22 SQL Data In: ORACLE - Param = 24, Name = AS_YJJXH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 17:00:22 SQL Data In: ORACLE - Param = 25, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 37 17:00:22 SQL Data In: ORACLE - Param = 26, Name = AS_SFYB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 38 17:00:22 SQL Data In: ORACLE - Param = 27, Name = AS_TSBZBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 39 17:00:22 SQL Data In: ORACLE - Param = 28, Name = AD_XJYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 40 17:00:22 SQL Data In: ORACLE - Param = 29, Name = AD_ZZYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 41 17:00:22 SQL Data In: ORACLE - Param = 30, Name = AD_JZDH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 42 17:00:22 SQL Data In: ORACLE - Param = 31, Name = AD_ZFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 43 17:00:22 SQL Data In: ORACLE - Param = 32, Name = AD_GRDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 44 17:00:22 SQL Data In: ORACLE - Param = 33, Name = AD_TJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 45 17:00:22 SQL Data In: ORACLE - Param = 34, Name = AD_SBZHDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 46 17:00:22 SQL Data In: ORACLE - Param = 35, Name = AD_SBTJDH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 47 17:00:22 SQL Data In: ORACLE - Param = 36, Name = AD_JJDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 48 17:00:22 SQL Data In: ORACLE - Param = 37, Name = AD_SYDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 49 17:00:22 SQL Data In: ORACLE - Param = 38, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 50 17:00:22 SQL Data In: ORACLE - Param = 39, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 51 17:00:22 SQL Data In: ORACLE - Param = 40, Name = AD_HJJE01, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 52 17:00:22 SQL Data In: ORACLE - Param = 41, Name = as_sfdyfp, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 53 17:00:22 SQL Execute: ORACLE - BEGIN "SP_SF_BRFY00_JS0000" (AS_YBDJH0 => :AS_YBDJH0,AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AS_GHH000 => :AS_GHH000,AS_ICKH00 => :AS_ICKH00,AD_BRID00 => :AD_BRID00,AD_JFLBID => :AD_JFLBID,AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_BRFB00 => :AD_BRFB00,AD_BRZJE0 => :AD_BRZJE0,AD_JZJE00 => :AD_JZJE00,AD_GFJE00 => :AD_GFJE00,AD_HJJE00 => :AD_HJJE00,AD_JMJE00 => :AD_JMJE00,AS_ZPZH00 => :AS_ZPZH00,AD_GRZHZF => :AD_GRZHZF,AD_TCJJZF => :AD_TCJJZF,AD_ZFJE00 => :AD_ZFJE00,AD_JZY000 => :AD_JZY000,AS_JZYXM0 => :AS_JZYXM0,AD_JZYKS0 => :AD_JZYKS0,AS_JMYY00 => :AS_JMYY00,AS_YJJXH0 => :AS_YJJXH0,AS_CZBZ00 => :AS_CZBZ00,AS_SFYB00 => :AS_SFYB00,AS_TSBZBH => :AS_TSBZBH,AD_XJYE00 => :AD_XJYE00,AD_ZZYE00 => :AD_ZZYE00,AD_JZDH00 => :AD_JZDH00,AD_ZFDJH0 => :AD_ZFDJH0,AD_GRDJH0 => :AD_GRDJH0,AD_TJDJH0 => :AD_TJDJH0,AD_SBZHDH => :AD_SBZHDH,AD_SBTJDH => :AD_SBTJDH,AD_JJDJH0 => :AD_JJDJH0,AD_SYDJH0 => :AD_SYDJH0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AD_HJJE01 => :AD_HJJE01,as_sfdyfp => :as_sfdyfp); END; 54 17:00:22 SQL Execute: ORACLE - commit 55 17:00:22 SQL Data In: ORACLE - Rows affected = 0 56 17:00:22 SQL Execute: ORACLE - select * from vw_sf_fp0000 where jzdh00=1003077840 57 17:00:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 001001 58 17:00:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1003077840.000000 59 17:00:43 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 60 17:00:43 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 760.000000 61 17:00:43 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 付建平 62 17:00:43 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 63 17:00:43 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 64 17:00:43 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 200, Scale = 0, Data = 错误：转入的票据数据文本格式不正确！ 65 17:00:43 SQL Execute: ORACLE - insert into sf_zrkpqk(zrkpid,plbh00,jzdh00,pjxh00,zrrq00,zrsj00,czy000,czyxm0,pjzt00,cgbz00,bz0000) values(sq_sf_zrkpqk_zrkpid.nextval,?,?,?,to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24:mi:ss'),?,?,?,?,?) 66 17:00:43 SQL Error: ORACLE - ORA-01400: 无法将 NULL 插入 ("SD_HOSPITAL"."SF_ZRKPQK"."PJXH00") 67 17:00:43 SQL Data In: ORACLE - Rows affected = 0 68 17:00:43 SQL Execute: ORACLE - rollback 69 17:00:43 SQL Data In: ORACLE - Rows affected = 0