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

2       01:35:42  SQL Data In: ORACLE - Param = 1, Name = AS_KSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170411
3       01:35:42  SQL Data In: ORACLE - Param = 2, Name = AS_JSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20170411
4       01:35:42  SQL Data In: ORACLE - Param = 3, Name = AD_LJID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
5       01:35:42  SQL Data In: ORACLE - Param = 4, Name = AD_KSBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
6       01:35:42  SQL Data In: ORACLE - Param = 5, Name = AD_ID0000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
7       01:35:42  SQL Data In: ORACLE - Param = 6, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
8       01:35:42  SQL Data In: ORACLE - Param = 7, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
9       01:35:42  SQL Data In: ORACLE - Param = 8, Name = AS_YYID00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
10      01:35:42  SQL Execute: ORACLE - BEGIN "SP_ZS_LJ_WCQKTJ_LJ" (AS_KSRQ00 => :AS_KSRQ00,AS_JSRQ00 => :AS_JSRQ00,AD_LJID00 => :AD_LJID00,AD_KSBH00 => :AD_KSBH00,AD_ID0000 => :AD_ID0000,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG,AS_YYID00 => :AS_YYID00); END;
11      01:35:45  SQL Error: ORACLE - ORA-20002: ORA-01427: 单行子查询返回多个行！*ORA-01427: 单行子查询返回多个行执行存储过程错误:SP_ZS_LJ_WCQKTJ_LJ(,ad_ID0000,as_YHMSG0,as_SYSMSG)
ORA-06512: 在 "SD_HOSPITAL.SP_ZS_LJ_WCQKTJ_LJ", line 107
ORA-06512: 在 line 1

12      01:35:45  SQL Error: ORACLE - Unmapped SQL Error Code: 20002
13      01:35: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

14      01:35: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

15      01:36: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

16      01:36: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

17      01:36: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

18      01:36: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)  

19      01:36: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 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',487,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE 
  b.xh0000 = a.xh0000 AND JSYGBH = 1913
  AND b.JSKSBH = '487')
  AND (INSTR (',' || a.jsksbh || ',',',487,') > 0 or a.jsksbh is null)