1 15:32:40 SQL Prepare: ORACLE - select a.SFXNH0 from ic_ybbrlb a where YBMC00 = :1 2 15:32:40 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福州市医保中心 3 15:32:40 SQL Execute: ORACLE - select a.SFXNH0 from ic_ybbrlb a where YBMC00 = ? 4 15:32:40 SQL Misc: ORACLE - Set rowset size 5 15:32:40 SQL Stmt: ORACLE - Fetch 6 15:32:40 SQL Stmt: ORACLE - EOF 7 15:32:40 SQL Data Out: ORACLE - Column = 1, Name = SFXNH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 8 15:32:40 SQL Stmt: ORACLE - Reset 9 15:32:40 SQL Stmt: ORACLE - Close 10 15:32:40 SQL Prepare: ORACLE - begin SP_SF_YBXX00_REG000(127559,'A67467679','350103460811019','李珠俤','男','','流动职工退休人员（整体关闭改制','有效','退休人员','福州市医保中心',91.53,671); end; 11 15:32:40 SQL Execute: ORACLE - begin SP_SF_YBXX00_REG000(127559,'A67467679','350103460811019','李珠俤','男','','流动职工退休人员（整体关闭改制','有效','退休人员','福州市医保中心',91.53,671); end; 12 15:32:40 SQL Error: ORACLE - ORA-20002: ORA-20004: 数据没有找到！ORA-20020: ORA-04091: 表 SD_HOSPITAL.BM_BRXXB0 发生了变化, 触发器/函数不能读它 ORA-06512: 在 "SD_HOSPITAL.TR_YJ_YW0000_UPD_PACS", line 201 ORA-04088: 触发器 'SD_HOSPITAL.TR_YJ_YW0000_UPD_PACS' 执 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YBXX00_REG000", line 66 ORA-06512: 在 line 1 13 15:32:40 SQL Error: ORACLE - Unmapped SQL Error Code: 20002 14 15:32:40 SQL Stmt: ORACLE - Reset 15 15:32:40 SQL Data In: ORACLE - Rows affected = 0 16 15:32:40 SQL Stmt: ORACLE - Close 17 15:32:40 SQL Prepare: ORACLE - rollback 18 15:32:40 SQL Execute: ORACLE - rollback 19 15:32:40 SQL Data In: ORACLE - Rows affected = 0 20 15:32:40 SQL Stmt: ORACLE - Close 21 15:32:53 SQL Prepare: ORACLE - select * from ic_ybbrlb where YBMC00 = :1 22 15:32:53 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 14, Scale = 0, Data = 福州市医保中心 23 15:32:53 SQL Execute: ORACLE - select * from ic_ybbrlb where YBMC00 = ? 24 15:32:53 SQL Misc: ORACLE - Set rowset size 25 15:32:53 SQL Stmt: ORACLE - Fetch 26 15:32:53 SQL Stmt: ORACLE - EOF 27 15:32:53 SQL Data Out: ORACLE - Column = 1, Name = YBLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 2 28 15:32:53 SQL Data Out: ORACLE - Column = 2, Name = YBMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 福州市医保中心 29 15:32:53 SQL Data Out: ORACLE - Column = 3, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 30 15:32:53 SQL Data Out: ORACLE - Column = 4, Name = SFJSDW, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 31 15:32:53 SQL Data Out: ORACLE - Column = 5, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 32 15:32:53 SQL Data Out: ORACLE - Column = 6, Name = MRZFBL, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 1.000000 33 15:32:53 SQL Data Out: ORACLE - Column = 7, Name = MRYYDJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = A 34 15:32:53 SQL Data Out: ORACLE - Column = 8, Name = MRJMBL, Type = fldFLOAT, Precision = 3, Scale = 2, Data = 0.000000 35 15:32:53 SQL Data Out: ORACLE - Column = 9, Name = TSJK00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 36 15:32:53 SQL Data Out: ORACLE - Column = 10, Name = YBBHSB, Type = fldZSTRING, Precision = 100, Scale = 0, Data = N,14 37 15:32:53 SQL Data Out: ORACLE - Column = 11, Name = SFXNH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 38 15:32:53 SQL Data Out: ORACLE - Column = 12, Name = PXH000, Type = fldZSTRING, Precision = 3, Scale = 0, Data = NULL 39 15:32:53 SQL Data Out: ORACLE - Column = 13, Name = FYBQZ0, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 40 15:32:53 SQL Stmt: ORACLE - Reset 41 15:32:53 SQL Stmt: ORACLE - Close 42 15:32:53 SQL Stmt: ORACLE - Reset 43 15:32:53 SQL Stmt: ORACLE - Close 44 15:32:53 SQL Prepare: ORACLE - select count(*) from ZY_BRXXB0 where BRID00=127559 and CYRQ00 is null 45 15:32:53 SQL Execute: ORACLE - select count(*) from ZY_BRXXB0 where BRID00=127559 and CYRQ00 is null 46 15:32:53 SQL Misc: ORACLE - Set rowset size 47 15:32:53 SQL Stmt: ORACLE - Fetch 48 15:32:53 SQL Stmt: ORACLE - EOF 49 15:32:53 SQL Data Out: ORACLE - Column = 1, Name = COUNT(*), Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 50 15:32:53 SQL Prepare: ORACLE - BEGIN "SP_SF_BRXXB0_EDIT00" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,AS_BRGFZH => :AS_BRGFZH,AS_BRXM00 => :AS_BRXM00,AS_BRXB00 => :AS_BRXB00,AS_BRXX00 => :AS_BRXX00,AS_BRCSRQ => :AS_BRCSRQ,AS_BRHYZK => :AS_BRHYZK,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRGJ00 => :AS_BRGJ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_FBMC00 => :AS_FBMC00,AS_BRDYFW => :AS_BRDYFW,AS_BRDH00 => :AS_BRDH00,AS_BRJTDZ => :AS_BRJTDZ,AS_BRYB00 => :AS_BRYB00,AS_BRYB01 => :AS_BRYB01,AD_TYDWID => :AD_TYDWID,AS_TYDWMC => :AS_TYDWMC,AS_BRLXGX => :AS_BRLXGX,AS_BRLXXM => :AS_BRLXXM,AS_BRLXDZ => :AS_BRLXDZ,AS_BRLXDH => :AS_BRLXDH,AS_BRZTQK => :AS_BRZTQK,AS_BRJKQK => :AS_BRJKQK,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_BRLX00 => :AS_BRLX00,AS_YBICKH => :AS_YBICKH,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFMZ00 => :AS_SFMZ00,AD_SFYD00 => :AD_SFYD00,AS_SFYXJB => :AS_SFYXJB,AS_BRSZSF => :AS_BRSZSF,AS_BRSZS0 => :AS_BRSZS0,AS_BRSZZ0 => :AS_BRSZZ0,AS_BRSZC0 => :AS_BRSZC0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_TSSXMC => :AS_TSSXMC); END; 51 15:32:53 SQL Misc: ORACLE - Set stored procedure on or off 52 15:32:53 SQL Data In: ORACLE - Param = 1, Name = AD_BRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 127559.000000 53 15:32:53 SQL Data In: ORACLE - Param = 2, Name = AS_MRN000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 54 15:32:53 SQL Data In: ORACLE - Param = 3, Name = AS_BRBLH0, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 350102541901 55 15:32:53 SQL Data In: ORACLE - Param = 4, Name = AS_BRGFZH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 15:32:53 SQL Data In: ORACLE - Param = 5, Name = AS_BRXM00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 李珠俤 57 15:32:53 SQL Data In: ORACLE - Param = 6, Name = AS_BRXB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男 58 15:32:53 SQL Data In: ORACLE - Param = 7, Name = AS_BRXX00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 59 15:32:53 SQL Data In: ORACLE - Param = 8, Name = AS_BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19460811 60 15:32:53 SQL Data In: ORACLE - Param = 9, Name = AS_BRHYZK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 61 15:32:53 SQL Data In: ORACLE - Param = 10, Name = AS_BRZY00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 62 15:32:53 SQL Data In: ORACLE - Param = 11, Name = AS_BRMZ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 汉族 63 15:32:53 SQL Data In: ORACLE - Param = 12, Name = AS_BRGJ00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 中国 64 15:32:53 SQL Data In: ORACLE - Param = 13, Name = AS_BRZJLX, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 身份证 65 15:32:53 SQL Data In: ORACLE - Param = 14, Name = AS_BRZJBH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 66 15:32:53 SQL Data In: ORACLE - Param = 15, Name = AS_FBMC00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 医保 67 15:32:53 SQL Data In: ORACLE - Param = 16, Name = AS_BRDYFW, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 市直 68 15:32:53 SQL Data In: ORACLE - Param = 17, Name = AS_BRDH00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 69 15:32:53 SQL Data In: ORACLE - Param = 18, Name = AS_BRJTDZ, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 70 15:32:53 SQL Data In: ORACLE - Param = 19, Name = AS_BRYB00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 71 15:32:53 SQL Data In: ORACLE - Param = 20, Name = AS_BRYB01, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 72 15:32:53 SQL Data In: ORACLE - Param = 21, Name = AD_TYDWID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 73 15:32:53 SQL Data In: ORACLE - Param = 22, Name = AS_TYDWMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 流动职工退休人员（整体关闭改制 74 15:32:53 SQL Data In: ORACLE - Param = 23, Name = AS_BRLXGX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 75 15:32:53 SQL Data In: ORACLE - Param = 24, Name = AS_BRLXXM, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 76 15:32:53 SQL Data In: ORACLE - Param = 25, Name = AS_BRLXDZ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 77 15:32:53 SQL Data In: ORACLE - Param = 26, Name = AS_BRLXDH, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 78 15:32:53 SQL Data In: ORACLE - Param = 27, Name = AS_BRZTQK, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 退休人员 79 15:32:53 SQL Data In: ORACLE - Param = 28, Name = AS_BRJKQK, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 80 15:32:53 SQL Data In: ORACLE - Param = 29, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 671.000000 81 15:32:53 SQL Data In: ORACLE - Param = 30, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 82 15:32:53 SQL Data In: ORACLE - Param = 31, Name = AS_BRLX00, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 复诊 83 15:32:53 SQL Data In: ORACLE - Param = 32, Name = AS_YBICKH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 350102541901 84 15:32:53 SQL Data In: ORACLE - Param = 33, Name = AS_YBID00, Type = fldZSTRING, Precision = 15, Scale = 0, Data = 350103460811019 85 15:32:53 SQL Data In: ORACLE - Param = 34, Name = AS_YBLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 86 15:32:53 SQL Data In: ORACLE - Param = 35, Name = AS_SFMZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 87 15:32:53 SQL Data In: ORACLE - Param = 36, Name = AD_SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 88 15:32:53 SQL Data In: ORACLE - Param = 37, Name = AS_SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 89 15:32:53 SQL Data In: ORACLE - Param = 38, Name = AS_BRSZSF, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 福建省 90 15:32:53 SQL Data In: ORACLE - Param = 39, Name = AS_BRSZS0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 15:32:53 SQL Data In: ORACLE - Param = 40, Name = AS_BRSZZ0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 92 15:32:53 SQL Data In: ORACLE - Param = 41, Name = AS_BRSZC0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 93 15:32:53 SQL Data In: ORACLE - Param = 42, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 94 15:32:53 SQL Data In: ORACLE - Param = 43, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 95 15:32:53 SQL Data In: ORACLE - Param = 44, Name = AS_TSSXMC, Type = fldZSTRING, Precision = 4, Scale = 0, Data = 普通 96 15:32:53 SQL Execute: ORACLE - BEGIN "SP_SF_BRXXB0_EDIT00" (AD_BRID00 => :AD_BRID00,AS_MRN000 => :AS_MRN000,AS_BRBLH0 => :AS_BRBLH0,AS_BRGFZH => :AS_BRGFZH,AS_BRXM00 => :AS_BRXM00,AS_BRXB00 => :AS_BRXB00,AS_BRXX00 => :AS_BRXX00,AS_BRCSRQ => :AS_BRCSRQ,AS_BRHYZK => :AS_BRHYZK,AS_BRZY00 => :AS_BRZY00,AS_BRMZ00 => :AS_BRMZ00,AS_BRGJ00 => :AS_BRGJ00,AS_BRZJLX => :AS_BRZJLX,AS_BRZJBH => :AS_BRZJBH,AS_FBMC00 => :AS_FBMC00,AS_BRDYFW => :AS_BRDYFW,AS_BRDH00 => :AS_BRDH00,AS_BRJTDZ => :AS_BRJTDZ,AS_BRYB00 => :AS_BRYB00,AS_BRYB01 => :AS_BRYB01,AD_TYDWID => :AD_TYDWID,AS_TYDWMC => :AS_TYDWMC,AS_BRLXGX => :AS_BRLXGX,AS_BRLXXM => :AS_BRLXXM,AS_BRLXDZ => :AS_BRLXDZ,AS_BRLXDH => :AS_BRLXDH,AS_BRZTQK => :AS_BRZTQK,AS_BRJKQK => :AS_BRJKQK,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AS_BRLX00 => :AS_BRLX00,AS_YBICKH => :AS_YBICKH,AS_YBID00 => :AS_YBID00,AS_YBLB00 => :AS_YBLB00,AS_SFMZ00 => :AS_SFMZ00,AD_SFYD00 => :AD_SFYD00,AS_SFYXJB => :AS_SFYXJB,AS_BRSZSF => :AS_BRSZSF,AS_BRSZS0 => :AS_BRSZS0,AS_BRSZZ0 => :AS_BRSZZ0,AS_BRSZC0 => :AS_BRSZC0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_TSSXMC => :AS_TSSXMC); END; 97 15:32:53 SQL Stmt: ORACLE - Close