1       09:02:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 3856394.000000
2       09:02:39  SQL Execute: ORACLE -  select count(1) num from  VW_ZY_ZYZH00  where  BRZT00 = '3'
 and  BRID00 = ?

3       09:02:39  SQL Execute: ORACLE - select  SQ_ZY_BRJFB0_DJH000.nextval  NEWDJH   from  dual

4       09:02:39  SQL Data In: ORACLE - Param = 1, Name = AS_XM0000, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 刘和平
5       09:02:39  SQL Data In: ORACLE - Param = 2, Name = AS_XB0000, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 男
6       09:02:39  SQL Data In: ORACLE - Param = 3, Name = AD_CXDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 120639110.000000
7       09:02:39  SQL Data In: ORACLE - Param = 4, Name = AD_NEWDJH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 42896208.000000
8       09:02:39  SQL Data In: ORACLE - Param = 5, Name = AD_CZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1648.000000
9       09:02:39  SQL Data In: ORACLE - Param = 6, Name = AS_CZYXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈静霆
10      09:02:39  SQL Data In: ORACLE - Param = 7, Name = AD_CZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 673.000000
11      09:02:39  SQL Data In: ORACLE - Param = 8, Name = AS_SHRXM0, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 陈静霆
12      09:02:39  SQL Data In: ORACLE - Param = 9, Name = AS_SHRYY0, Type = fldZSTRING, Precision = 18, Scale = 0, Data = 重新结算并出院登记
13      09:02:39  SQL Data In: ORACLE - Param = 10, Name = AS_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
14      09:02:39  SQL Data In: ORACLE - Param = 11, Name = AS_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      09:02:39  SQL Execute: ORACLE - BEGIN "SP_ZY_TKJZ00_YJREG0" (AS_XM0000 => :AS_XM0000,AS_XB0000 => :AS_XB0000,AD_CXDJH0 => :AD_CXDJH0,AD_NEWDJH => :AD_NEWDJH,AD_CZY000 => :AD_CZY000,AS_CZYXM0 => :AS_CZYXM0,AD_CZYKS0 => :AD_CZYKS0,AS_SHRXM0 => :AS_SHRXM0,AS_SHRYY0 => :AS_SHRYY0,AS_YHMSG0 => :AS_YHMSG0,AS_SYSMSG => :AS_SYSMSG); END;
16      09:02:45  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 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673')
  AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null)  

17      09:02:55  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 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673')
  AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null)  

18      09:03:05  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 = '5') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',673,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1648,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1648 AND b.JSKSBH = '673')
  AND (INSTR (',' || a.jsksbh || ',',',673,') > 0 or a.jsksbh is null)