1       18:59:27  SQL Execute: ORACLE - select YFBMBH,YFBMMC,YFBMXZ,MRBZ00 from VW_BQ_YPFWFX
where SLBMBH = 2241
and YPLBBH = '0'
 and YFBMXZ in ('2','3') order by YFBMXZ 

2       18:59:27  SQL Execute: ORACLE - select * from VW_SS_MZCFMX where CFH000 = '42117937' and CXBZ00='Z'  and QLZT00='2'
 order by CFID00

3       18:59:27  SQL Execute: ORACLE - select * from VW_BQ_CFYPSC where YPNM00 = '9000010104'

4       18:59:27  SQL Execute: ORACLE - select * from VW_BQ_CFYPSC where YPNM00 = '9000085133'

5       18:59:30  SQL Execute: ORACLE -  select count(1) from YF_MZCF00 where bccfh0='42117937'

6       19:00:11  SQL Execute: ORACLE - update YF_MZCFMX set BCCXSL=YPZSL0 where cflsh0=42117937 and YPZSL0>0 

7       19:02:56  SQL Data In: ORACLE - Rows affected = 2
8       19:02:56  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'yyyymmdd') OraSysDate FROM DUAL

9       19:02:56  SQL Execute: ORACLE - SELECT To_Char(SYSDATE, 'hh24:mi:ss') OraSysDate FROM DUAL

10      19:02:56  SQL Data In: ORACLE - Param = 1, Name = POPFLAG, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2
11      19:02:56  SQL Data In: ORACLE - Param = 2, Name = PMZZYBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0
12      19:02:56  SQL Data In: ORACLE - Param = 3, Name = PTQDJH0, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 42117937
13      19:02:56  SQL Data In: ORACLE - Param = 4, Name = PCFID00, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
14      19:02:56  SQL Data In: ORACLE - Param = 5, Name = PCZY000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2721.000000
15      19:02:56  SQL Data In: ORACLE - Param = 6, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2241.000000
16      19:02:56  SQL Data In: ORACLE - Param = 7, Name = PCOMMIT, Type = fldZSTRING, Precision = 0, Scale = 0, Data = NULL
17      19:02:56  SQL Data In: ORACLE - Param = 8, Name = PZXCGBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
18      19:02:56  SQL Data In: ORACLE - Param = 9, Name = PTSXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
19      19:02:56  SQL Data In: ORACLE - Param = 10, Name = PXXXX00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
20      19:02:56  SQL Data In: ORACLE - Param = 11, Name = PSRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20220915
21      19:02:56  SQL Data In: ORACLE - Param = 12, Name = PSRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19:02:57
22      19:02:56  SQL Execute: ORACLE - BEGIN "SP_SS_YZTFSQ" (POPFLAG => :POPFLAG,PMZZYBZ => :PMZZYBZ,PTQDJH0 => :PTQDJH0,PCFID00 => :PCFID00,PCZY000 => :PCZY000,PCZYKS0 => :PCZYKS0,PCOMMIT => :PCOMMIT,PZXCGBZ => :PZXCGBZ,PTSXX00 => :PTSXX00,PXXXX00 => :PXXXX00,PSRRQ00 => :PSRRQ00,PSRSJ00 => :PSRSJ00); END;
23      19:02:56  SQL Error: ORACLE - ORA-20020: ORA-20010: 此处方费用已结算，请取消结算后再退药!！*调用过程: SP_YF_MZCFTY(421179372721) ;！*
ORA-06512: 在 "SD_HOSPITAL.SP_SS_YZTFSQ", line 141
ORA-06512: 在 line 1

24      19:02:56  SQL Error: ORACLE - Unmapped SQL Error Code: 20020
25      19:02:56  SQL Data In: ORACLE - Param = 1, Name = PYGBH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2721.000000
26      19:02:56  SQL Data In: ORACLE - Param = 2, Name = PCZYKS0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2241.000000
27      19:02:56  SQL Data In: ORACLE - Param = 3, Name = PCZXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 67769211.000000
28      19:02:56  SQL Execute: ORACLE - BEGIN "SP_XT_GETYHTZXHLIST" (PYGBH00 => :PYGBH00,PCZYKS0 => :PCZYKS0,PCZXH00 => :PCZXH00); END;
29      19:02:57  SQL Execute: ORACLE - select * from VW_XT_XTTSXX_YHXX a where XH0000 in (select XH0000 from XT_XTTSXX_XHTEMP where CZYBH0 = 2721 and CZXH00 = 67769211.00)