1       16:55:46  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 = '2') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',497,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',2121,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =2121 AND b.JSKSBH = '497')
  AND (INSTR (',' || a.jsksbh || ',',',497,') > 0 or a.jsksbh is null)  

2       16:55:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6782.000000
3       16:55:48  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000
4       16:55:48  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497.000000
5       16:55:48  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
6       16:55:48  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
7       16:55:48  SQL Execute: ORACLE - SELECT ZYH000,BRXM00,YPQLPC,YPMC00,YPGG00,LSDJ00,YPZSL0,QLDW00,CSL000||JLDW00 AS DJL000,PCMC00,
       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,THBZ00,CH0000,decode(SRCS00,-1,null,SRCS00) SRCS00,YEXM00
FROM YF_YZYPSQ
WHERE YPNM00=?
  AND BQBMBH=?
  AND YFBMBH=?
  AND QLZT00 IN ('0','1') 
  AND HZBZ00=?
  AND FYBZ00='1'
  AND CXBZ00='Z'
  AND nvl(SHBZ00,'0') LIKE ?
ORDER BY CH0000

8       16:55:48  SQL Execute: ORACLE - Commit

9       16:55:48  SQL Data In: ORACLE - Rows affected = 0
10      16:55:48  SQL Data In: ORACLE - Param = 1, Name = P_YPNM00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
11      16:55:48  SQL Data In: ORACLE - Param = 2, Name = P_YFBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 497.000000
12      16:55:48  SQL Data In: ORACLE - Param = 3, Name = P_BQBMBH, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000
13      16:55:48  SQL Data In: ORACLE - Param = 4, Name = P_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
14      16:55:48  SQL Data In: ORACLE - Param = 5, Name = P_CLBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
15      16:55:48  SQL Data In: ORACLE - Param = 6, Name = P_HZBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
16      16:55:48  SQL Data In: ORACLE - Param = 7, Name = P_CZYBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2121.000000
17      16:55:48  SQL Data In: ORACLE - Param = 8, Name = P_LYRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
18      16:55:48  SQL Data In: ORACLE - Param = 9, Name = P_FHRBH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = -1.000000
19      16:55:48  SQL Data In: ORACLE - Param = 10, Name = P_CKDH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
20      16:55:48  SQL Data In: ORACLE - Param = 11, Name = P_MESSAGE, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
21      16:55:48  SQL Data In: ORACLE - Param = 12, Name = P_PYR000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2121.000000
22      16:55:48  SQL Data In: ORACLE - Param = 13, Name = P_SHBZ00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
23      16:55:48  SQL Execute: ORACLE - BEGIN "SP_YF_BQYZFY" (P_YPNM00 => :P_YPNM00,P_YFBMBH => :P_YFBMBH,P_BQBMBH => :P_BQBMBH,P_ZYID00 => :P_ZYID00,P_CLBZ00 => :P_CLBZ00,P_HZBZ00 => :P_HZBZ00,P_CZYBH0 => :P_CZYBH0,P_LYRBH0 => :P_LYRBH0,P_FHRBH0 => :P_FHRBH0,P_CKDH00 => :P_CKDH00,P_MESSAGE => :P_MESSAGE,P_PYR000 => :P_PYR000,P_SHBZ00 => :P_SHBZ00); END;
24      16:55:48  SQL Error: ORACLE - ORA-20266: ORA-20010: 药品:曲克芦丁脑蛋白水解物注射液,库存不足 -12,3 15！*
ORA-06512: 在 "SD_HOSPITAL.TR_YF_YPCKD0_AFUPD", line 743
ORA-06512: 在 "SD_HOSPITAL.SP_YF_BQYZFY", line 477
ORA-06512: 在 line 1

25      16:55:48  SQL Error: ORACLE - Unmapped SQL Error Code: 20266
26      16:55:48  SQL Execute: ORACLE - Rollback

27      16:55:48  SQL Data In: ORACLE - Rows affected = 0