1       15:34:29  SQL Prepare: ORACLE - SELECT NVL(MAX(BMBH00),0) BMBH00 FROM vw_bm_ssbm00

2       15:34:29  SQL Execute: ORACLE - SELECT NVL(MAX(BMBH00),0) BMBH00 FROM vw_bm_ssbm00

3       15:34:29  SQL Prepare: ORACLE - SELECT zyh000,zyid00,brid00,xm0000,xb0000,csrq00,dqks00,dqbq00 from zy_brxxb0 where zyid00=284677

4       15:34:29  SQL Execute: ORACLE - SELECT zyh000,zyid00,brid00,xm0000,xb0000,csrq00,dqks00,dqbq00 from zy_brxxb0 where zyid00=284677

5       15:34:29  SQL Prepare: ORACLE - Select SQ_SS_YW0000_SSDH00.NextVal Val from Dual

6       15:34:29  SQL Execute: ORACLE - Select SQ_SS_YW0000_SSDH00.NextVal Val from Dual

7       15:34:29  SQL Prepare: ORACLE - insert into ss_yw0000 (ssdh00,mzzybz,zyhghh,zyghid,brid00,xm0000,xb0000,csrq00,
                            ssks00,sqys00,sqks00,sqbq00,sqr000,srkslb,yyssrq,yysssj,yybz00,
                            ssqsrq,ssqssj,czy000,JZBZ00,
                            ssys00,SSYSXM,SSZS00,sszsxm,mzys00,mzysxm,MZMC00,SSDJMC)
Values(:1,'1',:2,:3,:4,:5,:6,:7,
                 :8,:9,:10,:11, :12,'9',TO_CHAR(:13,'YYYYMMDD'),:14,'Y',
                   TO_CHAR(:15,'YYYYMMDD'),:16,0, 'N',
                   :17,:18,:19,:20,:21,:22,:23,:24)

8       15:34:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1649.000000
9       15:34:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 1100222
10      15:34:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 284677.000000
11      15:34:29  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1612588.000000
12      15:34:29  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 江东
13      15:34:29  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女
14      15:34:29  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19230506
15      15:34:29  SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 508.000000
16      15:34:29  SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
17      15:34:29  SQL Data In: ORACLE - Param = 10, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 491.000000
18      15:34:29  SQL Data In: ORACLE - Param = 11, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485.000000
19      15:34:29  SQL Data In: ORACLE - Param = 12, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000
20      15:34:29  SQL Data In: ORACLE - Param = 13, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 2/2/2011 0:0:0:0
21      15:34:29  SQL Data In: ORACLE - Param = 14, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
22      15:34:29  SQL Data In: ORACLE - Param = 15, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 2/2/2011 0:0:0:0
23      15:34:29  SQL Data In: ORACLE - Param = 16, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
24      15:34:29  SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1360
25      15:34:29  SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 安康
26      15:34:29  SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1595
27      15:34:29  SQL Data In: ORACLE - Param = 20, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈春兰
28      15:34:29  SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 9, Scale = 0, Data = 1595;1254
29      15:34:29  SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 11, Scale = 0, Data = 陈春兰;柴瑾
30      15:34:29  SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 局麻
31      15:34:29  SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 中手术
32      15:34:29  SQL Execute: ORACLE - insert into ss_yw0000 (ssdh00,mzzybz,zyhghh,zyghid,brid00,xm0000,xb0000,csrq00,
                            ssks00,sqys00,sqks00,sqbq00,sqr000,srkslb,yyssrq,yysssj,yybz00,
                            ssqsrq,ssqssj,czy000,JZBZ00,
                            ssys00,SSYSXM,SSZS00,sszsxm,mzys00,mzysxm,MZMC00,SSDJMC)
Values(?,'1',?,?,?,?,?,?,
                 ?,?,?,?, ?,'9',TO_CHAR(?,'YYYYMMDD'),?,'Y',
                   TO_CHAR(?,'YYYYMMDD'),?,0, 'N',
                   ?,?,?,?,?,?,?,?)

33      15:34:29  SQL Error: ORACLE - ORA-20002: Err02: 该住院病人不存在！ZYH000=1100222
ORA-06512: 在 "SD_HOSPITAL.TR_SS_YW0000_BEFORE", line 59
ORA-04088: 触发器 'SD_HOSPITAL.TR_SS_YW0000_BEFORE' 执行过程中出错

34      15:34:29  SQL Error: ORACLE - Unmapped SQL Error Code: 20002
35      15:34:29  SQL Prepare: ORACLE - RollBack

36      15:34:29  SQL Execute: ORACLE - RollBack

37      15:34:29  SQL Data In: ORACLE - Rows affected = 0