1       15:04:59  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

2       15:05:04  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

3       15:05:07  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000
4       15:05:07  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31033462.000000
5       15:05:07  SQL Execute: ORACLE - update YF_YZYPSQ
set BCCXSL = ?
Where YPQLPC = ?

6       15:05:07  SQL Data In: ORACLE - Rows affected = 1
7       15:05:07  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
8       15:05:07  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31033466.000000
9       15:05:07  SQL Execute: ORACLE - update YF_YZYPSQ
set BCCXSL = ?
Where YPQLPC = ?

10      15:05:07  SQL Data In: ORACLE - Rows affected = 1
11      15:05:07  SQL Execute: ORACLE - COMMIT WORK
12      15:05:07  SQL Data In: ORACLE - Param = 1, Name = PTQDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 6024401.000000
13      15:05:07  SQL Data In: ORACLE - Param = 2, Name = PYZID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
14      15:05:07  SQL Data In: ORACLE - Param = 3, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 947.000000
15      15:05:07  SQL Data In: ORACLE - Param = 4, Name = PZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
16      15:05:07  SQL Data In: ORACLE - Param = 5, Name = PYPQLPC, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 31033466.000000
17      15:05:07  SQL Data In: ORACLE - Param = 6, Name = PSFBFTY, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000
18      15:05:07  SQL Execute: ORACLE - BEGIN "SP_BQ_YZYPTY" (PTQDJH0 => :PTQDJH0,PYZID00 => :PYZID00,PCZY000 => :PCZY000,PZYID00 => :PZYID00,PYPQLPC => :PYPQLPC,PSFBFTY => :PSFBFTY); END;
19      15:05:07  SQL Error: ORACLE - ORA-20020: ORA-20005: 该药品已作废！*！*
ORA-06512: 在 "SD_HOSPITAL.SP_BQ_YZYPTY", line 1177
ORA-06512: 在 line 1

20      15:05:07  SQL Error: ORACLE - Unmapped SQL Error Code: 20020
21      15:05:09  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

22      15:05:09  SQL Execute: ORACLE -  select * from zs_xxjlb0 a, vw_bq_yzll02 b where a.sfll00=1 and a.JSKSBH=28 and b.yzzt00 in ('0','1') and (b.xxid00>0) and (a.xxid00=b.xxid00) and  
 (sysdate-to_date(A.xxdqrq||' '||A.XXDQSJ,'YYYYMMDD HH24:MI:SS'))*24*60>5 

23      15:05:14  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

24      15:05:19  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

25      15:05:24  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

26      15:05:29  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

27      15:05:29  SQL Execute: ORACLE -  select * from zs_xxjlb0 a, vw_bq_yzll02 b where a.sfll00=1 and a.JSKSBH=28 and b.yzzt00 in ('0','1') and (b.xxid00>0) and (a.xxid00=b.xxid00) and  
 (sysdate-to_date(A.xxdqrq||' '||A.XXDQSJ,'YYYYMMDD HH24:MI:SS'))*24*60>5 

28      15:05:34  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

29      15:05:39  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

30      15:05:44  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

31      15:05:49  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

32      15:05:49  SQL Execute: ORACLE -  select * from zs_xxjlb0 a, vw_bq_yzll02 b where a.sfll00=1 and a.JSKSBH=28 and b.yzzt00 in ('0','1') and (b.xxid00>0) and (a.xxid00=b.xxid00) and  
 (sysdate-to_date(A.xxdqrq||' '||A.XXDQSJ,'YYYYMMDD HH24:MI:SS'))*24*60>5 

33      15:05:54  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

34      15:05:59  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0 

35      15:06:04  SQL Execute: ORACLE - select * from zs_xxjlb0 where (JSFBH0=947 or (JSKSBH=28 and JSFBH0=0))
 and XXCSFX=0 and SFLL00=0