1       11:04: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 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',764,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '764')
  AND (INSTR (',' || a.jsksbh || ',',',764,') > 0 or a.jsksbh is null)  

2       11:04:11  SQL Execute: ORACLE - select Value0 from XT_XTCS00 where name00 = 'YZ_XZHDHS'

3       11:04:11  SQL Data In: ORACLE - Param = 1, Name = P_MODE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
4       11:04:11  SQL Data In: ORACLE - Param = 2, Name = P_YZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 19792600.000000
5       11:04:11  SQL Data In: ORACLE - Param = 3, Name = P_HDR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1913.000000
6       11:04:11  SQL Data In: ORACLE - Param = 4, Name = P_TZYS00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       11:04:11  SQL Data In: ORACLE - Param = 5, Name = P_TZRXM0, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
8       11:04:11  SQL Data In: ORACLE - Param = 6, Name = P_TZRQ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
9       11:04:11  SQL Data In: ORACLE - Param = 7, Name = P_TZSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
10      11:04:11  SQL Data In: ORACLE - Param = 8, Name = P_PXSJ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
11      11:04:11  SQL Execute: ORACLE - BEGIN "SP_BQ_YPYZQT" (P_MODE00 => :P_MODE00,P_YZID00 => :P_YZID00,P_HDR000 => :P_HDR000,P_TZYS00 => :P_TZYS00,P_TZRXM0 => :P_TZRXM0,P_TZRQ00 => :P_TZRQ00,P_TZSJ00 => :P_TZSJ00,P_PXSJ00 => :P_PXSJ00); END;
12      11:04:11  SQL Error: ORACLE - ORA-20002: ORA-20001: ORA-04091: 表 SD_BQ.BQ_YPYZ00 发生了变化, 触发器/函数不能读它！*
ORA-06512: 在 "SD_HOSPITAL.TR_BQ_YPYZCF_BDEL
ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YPYZQT", line 546
ORA-06512: 在 line 1

13      11:04:11  SQL Error: ORACLE - Unmapped SQL Error Code: 20002
14      11:04:11  SQL Execute: ORACLE - RollBack

15      11:04:11  SQL Data In: ORACLE - Rows affected = 0
16      11:04: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 = '9') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',764,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1913,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1913 AND b.JSKSBH = '764')
  AND (INSTR (',' || a.jsksbh || ',',',764,') > 0 or a.jsksbh is null)