1 16:12:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 2 16:12:32 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75320.000000 3 16:12:32 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 4 16:12:32 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 5 16:12:32 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 6 16:12:32 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 7 16:12:32 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 8 16:12:32 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 9 16:12:32 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:00:00 10 16:12:32 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12:00:00 11 16:12:32 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 12 16:12:32 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 13 16:12:32 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 14 16:12:32 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 15 16:12:32 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 16 16:12:32 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 17 16:12:32 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 18 16:12:32 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 19 16:12:32 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 20 16:12:32 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 21 16:12:32 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 22 16:12:32 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 23 16:12:32 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 24 16:12:32 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 25 16:12:32 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 26 16:12:32 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 27 16:12:32 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 28 16:12:32 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 29 16:12:32 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 30 16:12:32 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YSGHHB_EDIT00", line 313 ORA-20281: 修改或增加挂号号表ID75320的挂号号表失败,原因:挂号限号数至少应该是预约限号数的两倍!* ORA-06512: 在 "SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL", line 310 ORA-04088: 触发器 'SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL' 执行过程中出错 ORA-06512: 在 line 1 31 16:12:32 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 32 16:12:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 33 16:12:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 34 16:12:59 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 35 16:13:09 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 36 16:13:19 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 37 16:13:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 38 16:13:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 39 16:13:48 SQL Execute: ORACLE - select * from vw_sf_ysghhb where 1 = 1 and GHMZSJ >= '20160427' and GHMZSJ <= '20160427' and YSXM00 = '王焕文' AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21) and PBLX00='0' order by GHMZSJ,YSXM00,GHQSSJ 40 16:13:48 SQL Execute: ORACLE - select * from vw_sf_ysghhb where 1 = 1 and GHMZSJ >= '20160427' and GHMZSJ <= '20160427' and YSXM00 = '王焕文' AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21) and PBLX00='0' order by GHMZSJ,YSXM00,GHQSSJ 41 16:13:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 42 16:13:50 SQL Execute: ORACLE - select * from BM_CKBM00 where FLAG00 = '4' and BMBH00 =478 43 16:13:50 SQL Execute: ORACLE - select * from VW_BM_GHLBB0 44 16:13:52 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75321.000000 45 16:13:52 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 46 16:13:52 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 47 16:13:52 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 48 16:13:52 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 49 16:13:52 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 50 16:13:52 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 51 16:13:52 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:00:00 52 16:13:52 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:00:00 53 16:13:52 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 54 16:13:52 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4.000000 55 16:13:52 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 56 16:13:52 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 57 16:13:52 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 58 16:13:52 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 59 16:13:52 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 60 16:13:52 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 61 16:13:52 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 62 16:13:52 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 63 16:13:52 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 64 16:13:52 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 65 16:13:52 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 66 16:13:52 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 67 16:13:52 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 68 16:13:52 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 69 16:13:52 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL 70 16:13:52 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 71 16:13:52 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 72 16:13:52 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YSGHHB_EDIT00", line 313 ORA-20281: 修改或增加挂号号表ID75321的挂号号表失败,原因:挂号限号数至少应该是预约限号数的两倍!* ORA-06512: 在 "SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL", line 310 ORA-04088: 触发器 'SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL' 执行过程中出错 ORA-06512: 在 line 1 73 16:13:52 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 74 16:13:54 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75321.000000 75 16:13:54 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 76 16:13:54 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 77 16:13:54 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 78 16:13:54 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 79 16:13:54 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 80 16:13:54 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 81 16:13:54 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:00:00 82 16:13:54 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:00:00 83 16:13:54 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 84 16:13:54 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3.000000 85 16:13:54 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 86 16:13:54 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 87 16:13:54 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 88 16:13:54 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 89 16:13:54 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 90 16:13:54 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 91 16:13:54 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 92 16:13:54 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 93 16:13:54 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 94 16:13:54 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 95 16:13:54 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 96 16:13:54 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 97 16:13:54 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 98 16:13:54 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 99 16:13:54 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL 100 16:13:54 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 101 16:13:54 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 102 16:13:54 SQL Execute: ORACLE - select * from vw_sf_ysghhb where 1 = 1 and GHMZSJ >= '20160427' and GHMZSJ <= '20160427' and YSXM00 = '王焕文' AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21) and PBLX00='0' order by GHMZSJ,YSXM00,GHQSSJ 103 16:13:56 SQL Execute: ORACLE - select * from BM_CKBM00 where FLAG00 = '4' and BMBH00 =478 104 16:13:56 SQL Execute: ORACLE - select * from VW_BM_GHLBB0 105 16:13:59 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75320.000000 106 16:13:59 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 107 16:13:59 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 108 16:13:59 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 109 16:13:59 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 110 16:13:59 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 111 16:13:59 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 112 16:13:59 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 08:00:00 113 16:13:59 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 12:00:00 114 16:13:59 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 12.000000 115 16:13:59 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6.000000 116 16:13:59 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 117 16:13:59 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 118 16:13:59 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 119 16:13:59 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 120 16:13:59 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 121 16:13:59 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 122 16:13:59 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 123 16:13:59 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 124 16:13:59 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 125 16:13:59 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 126 16:13:59 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 127 16:13:59 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 128 16:13:59 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 129 16:13:59 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 130 16:13:59 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 131 16:13:59 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 132 16:13:59 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 133 16:13:59 SQL Execute: ORACLE - select * from vw_sf_ysghhb where 1 = 1 and GHMZSJ >= '20160427' and GHMZSJ <= '20160427' and YSXM00 = '王焕文' AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21) and PBLX00='0' order by GHMZSJ,YSXM00,GHQSSJ 134 16:13:59 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 135 16:14:09 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 136 16:14:19 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 137 16:14:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 138 16:14:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 139 16:14:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 140 16:14:59 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 141 16:15:09 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 142 16:15:19 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 143 16:15:24 SQL Execute: ORACLE - select * from BM_CKBM00 where FLAG00 = '4' and BMBH00 =478 144 16:15:24 SQL Execute: ORACLE - select * from VW_BM_GHLBB0 145 16:15:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 146 16:15:39 SQL Execute: ORACLE - select * from BM_CKBM00 where FLAG00 = '4' and BMBH00 =478 147 16:15:39 SQL Execute: ORACLE - select * from VW_BM_GHLBB0 148 16:15:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 149 16:15:43 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75321.000000 150 16:15:43 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 151 16:15:43 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 152 16:15:43 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 153 16:15:43 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 154 16:15:43 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 155 16:15:43 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 156 16:15:43 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:00:00 157 16:15:43 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:00:00 158 16:15:43 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 159 16:15:43 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 160 16:15:43 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 161 16:15:43 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 162 16:15:43 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 163 16:15:43 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 164 16:15:43 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 165 16:15:43 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 166 16:15:43 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 167 16:15:43 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 168 16:15:43 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 169 16:15:43 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 170 16:15:43 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 171 16:15:43 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 172 16:15:43 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 173 16:15:43 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 174 16:15:43 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL 175 16:15:43 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 176 16:15:43 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 177 16:15:43 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YSGHHB_EDIT00", line 313 ORA-20281: 修改或增加挂号号表ID75321的挂号号表失败,原因:挂号限号数至少应该是预约限号数的两倍!* ORA-06512: 在 "SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL", line 310 ORA-04088: 触发器 'SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL' 执行过程中出错 ORA-06512: 在 line 1 178 16:15:43 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 179 16:15:43 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75321.000000 180 16:15:43 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 181 16:15:43 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 182 16:15:43 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 183 16:15:43 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 184 16:15:43 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 185 16:15:43 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 186 16:15:43 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:00:00 187 16:15:43 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:00:00 188 16:15:43 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 189 16:15:43 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 190 16:15:43 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 191 16:15:43 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 192 16:15:43 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 193 16:15:43 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 194 16:15:43 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 195 16:15:43 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 196 16:15:43 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 197 16:15:43 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 198 16:15:43 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 199 16:15:43 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 200 16:15:43 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 201 16:15:43 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 202 16:15:43 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 203 16:15:43 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 204 16:15:43 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL 205 16:15:43 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 206 16:15:43 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 207 16:15:43 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YSGHHB_EDIT00", line 313 ORA-20281: 修改或增加挂号号表ID75321的挂号号表失败,原因:挂号限号数至少应该是预约限号数的两倍!* ORA-06512: 在 "SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL", line 310 ORA-04088: 触发器 'SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL' 执行过程中出错 ORA-06512: 在 line 1 208 16:15:43 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 209 16:15:43 SQL Data In: ORACLE - Param = 1, Name = AD_GHHBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 75321.000000 210 16:15:43 SQL Data In: ORACLE - Param = 2, Name = AD_GHKSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 478.000000 211 16:15:43 SQL Data In: ORACLE - Param = 3, Name = AD_GHZKBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 107.000000 212 16:15:43 SQL Data In: ORACLE - Param = 4, Name = AD_GHYSBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1266.000000 213 16:15:43 SQL Data In: ORACLE - Param = 5, Name = AS_CKMC00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 口腔科 214 16:15:43 SQL Data In: ORACLE - Param = 6, Name = AS_GHLBMC, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 副主任医师号 215 16:15:43 SQL Data In: ORACLE - Param = 7, Name = AS_GHMZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20160427 216 16:15:43 SQL Data In: ORACLE - Param = 8, Name = AS_GHQSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 14:00:00 217 16:15:43 SQL Data In: ORACLE - Param = 9, Name = AS_GHJSSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:00:00 218 16:15:43 SQL Data In: ORACLE - Param = 10, Name = AD_GHXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 219 16:15:43 SQL Data In: ORACLE - Param = 11, Name = AD_YYXHS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 220 16:15:43 SQL Data In: ORACLE - Param = 12, Name = AD_GHYGHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 221 16:15:43 SQL Data In: ORACLE - Param = 13, Name = AD_GHYYHS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 222 16:15:43 SQL Data In: ORACLE - Param = 14, Name = AS_YYXHMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 223 16:15:43 SQL Data In: ORACLE - Param = 15, Name = AS_CZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 224 16:15:43 SQL Data In: ORACLE - Param = 16, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 225 16:15:43 SQL Data In: ORACLE - Param = 17, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 226 16:15:43 SQL Data In: ORACLE - Param = 18, Name = AS_FZYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 227 16:15:43 SQL Data In: ORACLE - Param = 19, Name = AS_FZYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 228 16:15:43 SQL Data In: ORACLE - Param = 20, Name = AS_DHYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 229 16:15:43 SQL Data In: ORACLE - Param = 21, Name = AS_DHYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 230 16:15:43 SQL Data In: ORACLE - Param = 22, Name = AS_WLYYS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 231 16:15:43 SQL Data In: ORACLE - Param = 23, Name = AS_WLYYMX, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL 232 16:15:43 SQL Data In: ORACLE - Param = 24, Name = AS_PJZZSJ, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 233 16:15:43 SQL Data In: ORACLE - Param = 25, Name = as_DHYY02, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 234 16:15:43 SQL Data In: ORACLE - Param = 26, Name = as_DHMX02, Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = NULL 235 16:15:43 SQL Data In: ORACLE - Param = 27, Name = as_ZZGHBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 236 16:15:43 SQL Execute: ORACLE - BEGIN "SP_SF_YSGHHB_EDIT00" (AD_GHHBID => :AD_GHHBID,AD_GHKSBH => :AD_GHKSBH,AD_GHZKBH => :AD_GHZKBH,AD_GHYSBH => :AD_GHYSBH,AS_CKMC00 => :AS_CKMC00,AS_GHLBMC => :AS_GHLBMC,AS_GHMZSJ => :AS_GHMZSJ,AS_GHQSSJ => :AS_GHQSSJ,AS_GHJSSJ => :AS_GHJSSJ,AD_GHXHS0 => :AD_GHXHS0,AD_YYXHS0 => :AD_YYXHS0,AD_GHYGHS => :AD_GHYGHS,AD_GHYYHS => :AD_GHYYHS,AS_YYXHMX => :AS_YYXHMX,AS_CZBZ00 => :AS_CZBZ00,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_FZYYS0 => :AS_FZYYS0,AS_FZYYMX => :AS_FZYYMX,AS_DHYYS0 => :AS_DHYYS0,AS_DHYYMX => :AS_DHYYMX,AS_WLYYS0 => :AS_WLYYS0,AS_WLYYMX => :AS_WLYYMX,AS_PJZZSJ => :AS_PJZZSJ,as_DHYY02 => :as_DHYY02,as_DHMX02 => :as_DHMX02,as_ZZGHBZ => :as_ZZGHBZ); END; 237 16:15:43 SQL Error: ORACLE - ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小 ORA-06512: 在 "SD_HOSPITAL.SP_SF_YSGHHB_EDIT00", line 313 ORA-20281: 修改或增加挂号号表ID75321的挂号号表失败,原因:挂号限号数至少应该是预约限号数的两倍!* ORA-06512: 在 "SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL", line 310 ORA-04088: 触发器 'SD_HOSPITAL.TR_SF_YSGHHB_BEFINSAPDEL' 执行过程中出错 ORA-06512: 在 line 1 238 16:15:43 SQL Error: ORACLE - Unmapped SQL Error Code: 6502 239 16:15:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 240 16:15:59 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 241 16:16:09 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 242 16:16:19 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 243 16:16:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 244 16:16:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 245 16:16:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 246 16:16:59 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 247 16:17:09 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 248 16:17:19 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 249 16:17:29 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 250 16:17:39 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null) 251 16:17:49 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 = 'D') ) and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',721,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 1913 AND b.JSKSBH = '721') AND (INSTR (',' || a.jsksbh || ',',',721,') > 0 or a.jsksbh is null)