1 16:04:29 SQL Prepare: ORACLE - BEGIN "SP_YJ_CF0000" (P_MODE00 => :P_MODE00,P_MZLB00 => :P_MZLB00,P_CFID00 => :P_CFID00,P_CFLSH0 => :P_CFLSH0,P_YFBMBH => :P_YFBMBH,P_CFMBMC => :P_CFMBMC,P_MZZYBZ => :P_MZZYBZ,P_BRID00 => :P_BRID00,P_ZYGHID => :P_ZYGHID,P_KDYS00 => :P_KDYS00,P_YJKSBH => :P_YJKSBH,P_YPLBBH => :P_YPLBBH,P_CFXZ00 => :P_CFXZ00,P_ZYTS00 => :P_ZYTS00,P_BZID00 => :P_BZID00,P_LRR000 => :P_LRR000,P_LRRXM0 => :P_LRRXM0,P_CFZJE0 => :P_CFZJE0,P_BRDZ00 => :P_BRDZ00,P_CFZT00 => :P_CFZT00,P_SFKSLY => :P_SFKSLY,P_PSZT00 => :P_PSZT00,P_DQBQ00 => :P_DQBQ00,P_ZYDJS0 => :P_ZYDJS0,P_YEXM00 => :P_YEXM00,p_sfzh00 => :p_sfzh00,P_TSBZBH => :P_TSBZBH); END; 2 16:04:29 SQL Misc: ORACLE - Set stored procedure on or off 3 16:04:29 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 4 16:04:29 SQL Data In: ORACLE - Param = 2, Name = P_MZLB00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 5 16:04:29 SQL Data In: ORACLE - Param = 3, Name = P_CFID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33862.000000 6 16:04:29 SQL Data In: ORACLE - Param = 4, Name = P_CFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 700231 7 16:04:29 SQL Data In: ORACLE - Param = 5, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497.000000 8 16:04:29 SQL Data In: ORACLE - Param = 6, Name = P_CFMBMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 9 16:04:29 SQL Data In: ORACLE - Param = 7, Name = P_MZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 10 16:04:29 SQL Data In: ORACLE - Param = 8, Name = P_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4137810.000000 11 16:04:29 SQL Data In: ORACLE - Param = 9, Name = P_ZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 754873.000000 12 16:04:29 SQL Data In: ORACLE - Param = 10, Name = P_KDYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1338.000000 13 16:04:29 SQL Data In: ORACLE - Param = 11, Name = P_YJKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 555.000000 14 16:04:29 SQL Data In: ORACLE - Param = 12, Name = P_YPLBBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 16:04:29 SQL Data In: ORACLE - Param = 13, Name = P_CFXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 16 16:04:29 SQL Data In: ORACLE - Param = 14, Name = P_ZYTS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 17 16:04:29 SQL Data In: ORACLE - Param = 15, Name = P_BZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 18 16:04:29 SQL Data In: ORACLE - Param = 16, Name = P_LRR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1338.000000 19 16:04:29 SQL Data In: ORACLE - Param = 17, Name = P_LRRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 林信武 20 16:04:29 SQL Data In: ORACLE - Param = 18, Name = P_CFZJE0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 228.850000 21 16:04:29 SQL Data In: ORACLE - Param = 19, Name = P_BRDZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 16:04:29 SQL Data In: ORACLE - Param = 20, Name = P_CFZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 23 16:04:29 SQL Data In: ORACLE - Param = 21, Name = P_SFKSLY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 24 16:04:29 SQL Data In: ORACLE - Param = 22, Name = P_PSZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 25 16:04:29 SQL Data In: ORACLE - Param = 23, Name = P_DQBQ00, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 485 26 16:04:29 SQL Data In: ORACLE - Param = 24, Name = P_ZYDJS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 27 16:04:29 SQL Data In: ORACLE - Param = 25, Name = P_YEXM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 28 16:04:29 SQL Data In: ORACLE - Param = 26, Name = p_sfzh00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 29 16:04:29 SQL Data In: ORACLE - Param = 27, Name = P_TSBZBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 30 16:04:29 SQL Execute: ORACLE - BEGIN "SP_YJ_CF0000" (P_MODE00 => :P_MODE00,P_MZLB00 => :P_MZLB00,P_CFID00 => :P_CFID00,P_CFLSH0 => :P_CFLSH0,P_YFBMBH => :P_YFBMBH,P_CFMBMC => :P_CFMBMC,P_MZZYBZ => :P_MZZYBZ,P_BRID00 => :P_BRID00,P_ZYGHID => :P_ZYGHID,P_KDYS00 => :P_KDYS00,P_YJKSBH => :P_YJKSBH,P_YPLBBH => :P_YPLBBH,P_CFXZ00 => :P_CFXZ00,P_ZYTS00 => :P_ZYTS00,P_BZID00 => :P_BZID00,P_LRR000 => :P_LRR000,P_LRRXM0 => :P_LRRXM0,P_CFZJE0 => :P_CFZJE0,P_BRDZ00 => :P_BRDZ00,P_CFZT00 => :P_CFZT00,P_SFKSLY => :P_SFKSLY,P_PSZT00 => :P_PSZT00,P_DQBQ00 => :P_DQBQ00,P_ZYDJS0 => :P_ZYDJS0,P_YEXM00 => :P_YEXM00,p_sfzh00 => :p_sfzh00,P_TSBZBH => :P_TSBZBH); END; 31 16:04:29 SQL Stmt: ORACLE - Close 32 16:04:29 SQL Prepare: ORACLE - BEGIN "SP_YJ_CFMX00" (P_MODE00 => :P_MODE00,P_YBZXLB => :P_YBZXLB,P_ID0000 => :P_ID0000,P_CFID00 => :P_CFID00,P_YPNM00 => :P_YPNM00,P_YPMC00 => :P_YPMC00,P_YFID00 => :P_YFID00,P_PCID00 => :P_PCID00,P_CSL000 => :P_CSL000,P_YYSJ00 => :P_YYSJ00,P_YFSMMC => :P_YFSMMC,P_ZB0000 => :P_ZB0000,P_PSID00 => :P_PSID00,P_XMYFMC => :P_XMYFMC,P_YPZSL0 => :P_YPZSL0,P_CFDW00 => :P_CFDW00,P_ZHL000 => :P_ZHL000,P_SFXS00 => :P_SFXS00,P_YBBRLB => :P_YBBRLB,P_CFLSH0 => :P_CFLSH0); END; 33 16:04:29 SQL Misc: ORACLE - Set stored procedure on or off 34 16:04:29 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 35 16:04:29 SQL Data In: ORACLE - Param = 2, Name = P_YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 16:04:29 SQL Data In: ORACLE - Param = 3, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 37 16:04:29 SQL Data In: ORACLE - Param = 4, Name = P_CFID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33863.000000 38 16:04:29 SQL Data In: ORACLE - Param = 5, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5105.000000 39 16:04:29 SQL Data In: ORACLE - Param = 6, Name = P_YPMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 舒芬太尼注射液 40 16:04:29 SQL Data In: ORACLE - Param = 7, Name = P_YFID00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 93 41 16:04:29 SQL Data In: ORACLE - Param = 8, Name = P_PCID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 42 16:04:29 SQL Data In: ORACLE - Param = 9, Name = P_CSL000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 150 43 16:04:29 SQL Data In: ORACLE - Param = 10, Name = P_YYSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 44 16:04:29 SQL Data In: ORACLE - Param = 11, Name = P_YFSMMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 45 16:04:29 SQL Data In: ORACLE - Param = 12, Name = P_ZB0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 46 16:04:29 SQL Data In: ORACLE - Param = 13, Name = P_PSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 47 16:04:29 SQL Data In: ORACLE - Param = 14, Name = P_XMYFMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 48 16:04:29 SQL Data In: ORACLE - Param = 15, Name = P_YPZSL0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 49 16:04:29 SQL Data In: ORACLE - Param = 16, Name = P_CFDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 支 50 16:04:29 SQL Data In: ORACLE - Param = 17, Name = P_ZHL000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 50 51 16:04:29 SQL Data In: ORACLE - Param = 18, Name = P_SFXS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 52 16:04:29 SQL Data In: ORACLE - Param = 19, Name = P_YBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 53 16:04:29 SQL Data In: ORACLE - Param = 20, Name = P_CFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 700231 54 16:04:29 SQL Execute: ORACLE - BEGIN "SP_YJ_CFMX00" (P_MODE00 => :P_MODE00,P_YBZXLB => :P_YBZXLB,P_ID0000 => :P_ID0000,P_CFID00 => :P_CFID00,P_YPNM00 => :P_YPNM00,P_YPMC00 => :P_YPMC00,P_YFID00 => :P_YFID00,P_PCID00 => :P_PCID00,P_CSL000 => :P_CSL000,P_YYSJ00 => :P_YYSJ00,P_YFSMMC => :P_YFSMMC,P_ZB0000 => :P_ZB0000,P_PSID00 => :P_PSID00,P_XMYFMC => :P_XMYFMC,P_YPZSL0 => :P_YPZSL0,P_CFDW00 => :P_CFDW00,P_ZHL000 => :P_ZHL000,P_SFXS00 => :P_SFXS00,P_YBBRLB => :P_YBBRLB,P_CFLSH0 => :P_CFLSH0); END; 55 16:04:29 SQL Stmt: ORACLE - Close 56 16:04:29 SQL Prepare: ORACLE - BEGIN "SP_YJ_CFMX00" (P_MODE00 => :P_MODE00,P_YBZXLB => :P_YBZXLB,P_ID0000 => :P_ID0000,P_CFID00 => :P_CFID00,P_YPNM00 => :P_YPNM00,P_YPMC00 => :P_YPMC00,P_YFID00 => :P_YFID00,P_PCID00 => :P_PCID00,P_CSL000 => :P_CSL000,P_YYSJ00 => :P_YYSJ00,P_YFSMMC => :P_YFSMMC,P_ZB0000 => :P_ZB0000,P_PSID00 => :P_PSID00,P_XMYFMC => :P_XMYFMC,P_YPZSL0 => :P_YPZSL0,P_CFDW00 => :P_CFDW00,P_ZHL000 => :P_ZHL000,P_SFXS00 => :P_SFXS00,P_YBBRLB => :P_YBBRLB,P_CFLSH0 => :P_CFLSH0); END; 57 16:04:29 SQL Misc: ORACLE - Set stored procedure on or off 58 16:04:29 SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 59 16:04:29 SQL Data In: ORACLE - Param = 2, Name = P_YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 60 16:04:29 SQL Data In: ORACLE - Param = 3, Name = P_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 61 16:04:29 SQL Data In: ORACLE - Param = 4, Name = P_CFID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33863.000000 62 16:04:29 SQL Data In: ORACLE - Param = 5, Name = P_YPNM00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5105.000000 63 16:04:29 SQL Data In: ORACLE - Param = 6, Name = P_YPMC00, Type = fldZSTRING, Precision = 14, Scale = 0, Data = 舒芬太尼注射液 64 16:04:29 SQL Data In: ORACLE - Param = 7, Name = P_YFID00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 40 65 16:04:29 SQL Data In: ORACLE - Param = 8, Name = P_PCID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 16:04:29 SQL Data In: ORACLE - Param = 9, Name = P_CSL000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 25 67 16:04:29 SQL Data In: ORACLE - Param = 10, Name = P_YYSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 16:04:29 SQL Data In: ORACLE - Param = 11, Name = P_YFSMMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 69 16:04:29 SQL Data In: ORACLE - Param = 12, Name = P_ZB0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 70 16:04:29 SQL Data In: ORACLE - Param = 13, Name = P_PSID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 71 16:04:29 SQL Data In: ORACLE - Param = 14, Name = P_XMYFMC, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 72 16:04:29 SQL Data In: ORACLE - Param = 15, Name = P_YPZSL0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 73 16:04:29 SQL Data In: ORACLE - Param = 16, Name = P_CFDW00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 支 74 16:04:29 SQL Data In: ORACLE - Param = 17, Name = P_ZHL000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 50 75 16:04:29 SQL Data In: ORACLE - Param = 18, Name = P_SFXS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 76 16:04:29 SQL Data In: ORACLE - Param = 19, Name = P_YBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 77 16:04:29 SQL Data In: ORACLE - Param = 20, Name = P_CFLSH0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 700231 78 16:04:29 SQL Execute: ORACLE - BEGIN "SP_YJ_CFMX00" (P_MODE00 => :P_MODE00,P_YBZXLB => :P_YBZXLB,P_ID0000 => :P_ID0000,P_CFID00 => :P_CFID00,P_YPNM00 => :P_YPNM00,P_YPMC00 => :P_YPMC00,P_YFID00 => :P_YFID00,P_PCID00 => :P_PCID00,P_CSL000 => :P_CSL000,P_YYSJ00 => :P_YYSJ00,P_YFSMMC => :P_YFSMMC,P_ZB0000 => :P_ZB0000,P_PSID00 => :P_PSID00,P_XMYFMC => :P_XMYFMC,P_YPZSL0 => :P_YPZSL0,P_CFDW00 => :P_CFDW00,P_ZHL000 => :P_ZHL000,P_SFXS00 => :P_SFXS00,P_YBBRLB => :P_YBBRLB,P_CFLSH0 => :P_CFLSH0); END; 79 16:04:29 SQL Stmt: ORACLE - Close 80 16:04:29 SQL Prepare: ORACLE - BEGIN "SP_YJ_CFTJ00" (P_CFID00 => :P_CFID00,P_ICD000 => :P_ICD000,P_ZDMC00 => :P_ZDMC00); END; 81 16:04:29 SQL Misc: ORACLE - Set stored procedure on or off 82 16:04:29 SQL Data In: ORACLE - Param = 1, Name = P_CFID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 33863.000000 83 16:04:29 SQL Data In: ORACLE - Param = 2, Name = P_ICD000, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 84 16:04:29 SQL Data In: ORACLE - Param = 3, Name = P_ZDMC00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 85 16:04:29 SQL Execute: ORACLE - BEGIN "SP_YJ_CFTJ00" (P_CFID00 => :P_CFID00,P_ICD000 => :P_ICD000,P_ZDMC00 => :P_ZDMC00); END; 86 16:04:29 SQL Error: ORACLE - ORA-20009: 发生错误!*还回信息:ORA-01427: 单行子查询返回多个行 ORA-06512: 在 "SD_HOSPITAL.SP_YJ_CFTJ00", line 413 ORA-06512: 在 line 1 87 16:04:29 SQL Error: ORACLE - Unmapped SQL Error Code: 20009 88 16:04:29 SQL Stmt: ORACLE - Reset 89 16:04:29 SQL Stmt: ORACLE - Close