1       11:00:07  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'C') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',464,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '464')
  AND (INSTR (',' || a.jsksbh || ',',',464,') > 0 or a.jsksbh is null)  

2       11:00:08  Log started for: 后台维护系统
3       11:00:09  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 吴雅云
4       11:00:09  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 女
5       11:00:09  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 550908
6       11:00:09  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = wyy
7       11:00:09  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 3, Scale = 0, Data = kaf
8       11:00:09  SQL Data In: ORACLE - Param = 6, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 484.000000
9       11:00:09  SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
10      11:00:09  SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
11      11:00:09  SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
12      11:00:09  SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
13      11:00:09  SQL Data In: ORACLE - Param = 11, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
14      11:00:09  SQL Data In: ORACLE - Param = 12, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
15      11:00:09  SQL Data In: ORACLE - Param = 13, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
16      11:00:09  SQL Data In: ORACLE - Param = 14, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
17      11:00:09  SQL Data In: ORACLE - Param = 15, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1
18      11:00:09  SQL Data In: ORACLE - Param = 16, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 5.000000
19      11:00:09  SQL Data In: ORACLE - Param = 17, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
20      11:00:09  SQL Data In: ORACLE - Param = 18, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
21      11:00:09  SQL Data In: ORACLE - Param = 19, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
22      11:00:09  SQL Data In: ORACLE - Param = 20, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
23      11:00:09  SQL Data In: ORACLE - Param = 21, Name = , Type = fldZSTRING, Precision = 18, Scale = 0, Data = 352203199408256345
24      11:00:09  SQL Data In: ORACLE - Param = 22, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
25      11:00:09  SQL Data In: ORACLE - Param = 23, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
26      11:00:09  SQL Data In: ORACLE - Param = 24, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
27      11:00:09  SQL Data In: ORACLE - Param = 25, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
28      11:00:09  SQL Data In: ORACLE - Param = 26, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
29      11:00:09  SQL Data In: ORACLE - Param = 27, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
30      11:00:09  SQL Execute: ORACLE - insert into bm_ygbm00
  (YGBH00, ZWXM00, XB0000, XKH000, 
   PYSM00, WBSM00, BMBH00, YGXZ00, YSLB00, 
   CFJB00, GZDJ00, MZDJ00, DPDJ00, SJDJ00, KSSJB0,
   DLMM00, CZBZ00, BRID00, MRGHLB, SSDJ00, YLFL00,DH0000, 
   CZY001, CZRQ01, CZSJ01,YSZJHM,YNGZFZ,YSFLBH,SFZBH0,SXSPDJ,FZYYDJ,YSTCBL)
values
  (SQ_BM_YGBM00_YGBH00.NextVal, TRIM(?), ?, TRIM(?), 
  ?, ?, ?, ?, ?,
  ?, ?, ?, ?, ?,?,
  'hplZOq6iScaqyo', ?, SQ_BM_BRXXB0_BRID00.NextVal,
  ?, ?, ?, ?,
  ?, TO_CHAR(sysdate, 'YYYYMMDD'), TO_CHAR
(sysdate,'HH24:MI:SS'),?,?,?,?,?,?,?)
 
 
 
 
 
 

31      11:00:09  SQL Error: ORACLE - ORA-20902: 胸卡号必须唯一。*
ORA-06512: 在 "SD_HOSPITAL.TR_BM_YGBM00_BEFORE_VALID0", line 30
ORA-04088: 触发器 'SD_HOSPITAL.TR_BM_YGBM00_BEFORE_VALID0' 执行过程中出错

32      11:00:09  SQL Error: ORACLE - Unmapped SQL Error Code: 20902
33      11:00:11  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '6')) or XXXZ00='0')
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',464,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '464')
  AND (INSTR (',' || a.jsksbh || ',',',464,') > 0 or a.jsksbh is null)