1 09:19:47 SQL Execute: ORACLE - select * from VW_ZY_BQMC00 where BMXZ00 = '9' AND CZBZ00 <> '2' order by bh0000 2 09:19:50 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '1%' order by RYCWH0 3 09:19:50 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '10%' order by RYCWH0 4 09:19:51 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '105%' order by RYCWH0 5 09:19:51 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '1058%' order by RYCWH0 6 09:19:52 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '10584%' order by RYCWH0 7 09:19:52 SQL Execute: ORACLE - select B.BMMC00,A.* from zy_brxxb0 A,BM_BMBM00 B,IC_YBBRLB C where A.DQBQ00 = B.BMBH00 and A.YBLB00=C.YBLB00 AND A.FBBH00=C.FBBH00 AND cyrq00 is null and A.YBZYH0 <> '0' and ZYH000 like '105846%' order by RYCWH0 8 09:19:52 SQL Execute: ORACLE - select YBLB00 from BM_BRXXB0 where BRID00=1279949 9 09:19:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 929298.000000 10 09:19:52 SQL Execute: ORACLE - select sum(a.HJJE00) HJJE00 from ZY_FYMX00 b,zy_brfy00 a where a.zyid00 =? and a.JZDH00+0 = 0 and A.DJH000=B.DJH000 11 09:19:52 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1279949.000000 12 09:19:52 SQL Execute: ORACLE - select a.*,b.sfxnh0 from bm_brxxb0 a,ic_ybbrlb b where a.fbbh00=b.fbbh00 and a.yblb00=b.yblb00 and a.brid00 =? 13 09:19:52 SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 929298.000000 14 09:19:52 SQL Data In: ORACLE - Param = 2, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 15 09:19:52 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 16 09:19:52 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 17 09:19:52 SQL Execute: ORACLE - BEGIN "SP_ZY_ZYSFYB_YJS000" (AD_ZYID00 => :AD_ZYID00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 18 09:19:57 SQL Data In: ORACLE - Param = 1, Name = AD_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 929298.000000 19 09:19:57 SQL Data In: ORACLE - Param = 2, Name = AS_YJSJG0, Type = fldZSTRING, Precision = 161, Scale = 0, Data = 项目“★维生素C片”数量为负数,请与系统管理员联系!ORA-0000: normal, successful completion执行存储过程错误:SP_ZY_YBJK00_FJ0000(,,,ad_ID0000,as_YHMSG0,as_SYSMSG) 20 09:19:57 SQL Data In: ORACLE - Param = 3, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 21 09:19:57 SQL Data In: ORACLE - Param = 4, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 22 09:19:57 SQL Execute: ORACLE - BEGIN "SP_ZY_YBYJS0_ERROR0" (AD_ZYID00 => :AD_ZYID00,AS_YJSJG0 => :AS_YJSJG0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END; 23 09:21:32 Log started for: SQL Navigator for Oracle