1 10:37:58 SQL Prepare: ORACLE - BEGIN "SP_BQ_YZZXLJHLTS" (AD_BQID00 => :AD_BQID00,AD_BQBZ00 => :AD_BQBZ00,AS_TSBZ00 => :AS_TSBZ00,AS_BRXX00 => :AS_BRXX00); END; 2 10:37:58 SQL Misc: ORACLE - Set stored procedure on or off 3 10:37:58 SQL Data In: ORACLE - Param = 1, Name = AD_BQID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 308.000000 4 10:37:58 SQL Data In: ORACLE - Param = 2, Name = AD_BQBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 5 10:37:58 SQL Data In: ORACLE - Param = 3, Name = AS_TSBZ00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 6 10:37:58 SQL Data In: ORACLE - Param = 4, Name = AS_BRXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 7 10:37:58 SQL Execute: ORACLE - BEGIN "SP_BQ_YZZXLJHLTS" (AD_BQID00 => :AD_BQID00,AD_BQBZ00 => :AD_BQBZ00,AS_TSBZ00 => :AS_TSBZ00,AS_BRXX00 => :AS_BRXX00); END; 8 10:37:58 SQL Stmt: ORACLE - Close 9 10:37:58 SQL Prepare: ORACLE - select SQ_BM_ZYTEMP_TQID.NEXTVAL from dual 10 10:37:58 SQL Execute: ORACLE - select SQ_BM_ZYTEMP_TQID.NEXTVAL from dual 11 10:37:58 SQL Stmt: ORACLE - Fetch 12 10:37:58 SQL Data Out: ORACLE - Column = 1, Name = NEXTVAL, Type = fldFLOAT, Precision = 38, Scale = 10, Data = 47242.000000 13 10:37:58 SQL Stmt: ORACLE - Fetch 14 10:37:58 SQL Stmt: ORACLE - EOF 15 10:37:58 SQL Stmt: ORACLE - Reset 16 10:37:58 SQL Stmt: ORACLE - Close 17 10:37:58 SQL Prepare: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00,PTQID00 => :PTQID00); END; 18 10:37:58 SQL Misc: ORACLE - Set stored procedure on or off 19 10:37:58 SQL Data In: ORACLE - Param = 1, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 887.000000 20 10:37:58 SQL Data In: ORACLE - Param = 2, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 585005.000000 21 10:37:58 SQL Data In: ORACLE - Param = 3, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 308.000000 22 10:37:58 SQL Data In: ORACLE - Param = 4, Name = PCLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 23 10:37:58 SQL Data In: ORACLE - Param = 5, Name = PYFLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 10:37:58 SQL Data In: ORACLE - Param = 6, Name = PYPLBBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 25 10:37:58 SQL Data In: ORACLE - Param = 7, Name = PZXRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 4/13/2015 0:0:0:0 26 10:37:58 SQL Data In: ORACLE - Param = 8, Name = PTQID00, Type = fldZSTRING, Precision = 5, Scale = 0, Data = 47242 27 10:37:58 SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZZX" (PCZY000 => :PCZY000,PZYID00 => :PZYID00,PBQH000 => :PBQH000,PCLBZ00 => :PCLBZ00,PYFLBID => :PYFLBID,PYPLBBH => :PYPLBBH,PZXRQ00 => :PZXRQ00,PTQID00 => :PTQID00); END; 28 10:37:58 SQL Error: ORACLE - ORA-20020: ORA-20020: ORA-20020: ORA-20007: 物资ID=2601,项目数量*金额<>合计金额:2*.5616<>1.12,不能收费! ORA-06512: 在 "SD_HOSPITAL.TR_WZ_ZY_FYMX00_INS", line 311 ORA-04088: 触发器 'SD_HOSPITAL.TR_WZ_ZY!*SP_BQ_YPYZZX(887,585005,30 ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YPYZZX", line 91 ORA-06512: 在 line 1 29 10:37:58 SQL Error: ORACLE - Unmapped SQL Error Code: 20020 30 10:37:58 SQL Stmt: ORACLE - Reset 31 10:37:58 SQL Stmt: ORACLE - Close