1       15:11:29  SQL Execute: ORACLE - select YYID00,YYH000 from YJ_YYBRB0 where YJDJH0 in (13804719) and YYZT00 in ('0') 

2       15:11:56  SQL Execute: ORACLE -  select a.*, b.YYH000, b.YYSD00,b.JKYYH0,to_char(to_date(b.YYRQ00,'YYYYMMDD'),'YYYY.MM.DD') YYRQ00,b.JCSQDH,b.BRDH00,b.PBHBID,to_date(b.YYRQ00,'YYYY.MM.DD') YYDATE,b.JZBZ00 YYJZBZ from VW_YJ_YW0000 a,YJ_YYBRB0 b where a.YJDJH0 in (13804719) 
 and a.BRID00=4152454 and a.YJDJH0=b.YJDJH0 and b.YYID00 in(6724)

3       15:11:56  SQL Execute: ORACLE - select * from BM_CKBM00 where FLAG00='7' and ZT0000='0' and BMBH00=502

4       15:11:56  SQL Execute: ORACLE - select a.*   from VW_YJ_JCPBYHMX a   
 where  a.YJKSBH=502
 and a.YYRQ00='20150331'
  and (nvl(a.JCLBID,0)=2 or nvl(a.JCLBID,0)=0 )
  and (nvl(a.XMWHID,0)=16 or  nvl(a.XMWHID,0)=0)
 and a.PBSXW0='下午'
  and (MZZYBZ='2' or MZZYBZ='1')
 order by YYSJ00,a.XH0000  

5       15:11:56  SQL Execute: ORACLE - select nvl(max(XH0000),0) XH0000 from (select a.*   from VW_YJ_JCPBYHMX a   
 where  a.YJKSBH=502
 and a.YYRQ00='20150331'
  and (nvl(a.JCLBID,0)=2 or nvl(a.JCLBID,0)=0 )
  and (nvl(a.XMWHID,0)=16 or  nvl(a.XMWHID,0)=0)
 and a.PBSXW0='下午'
  and (MZZYBZ='2' or MZZYBZ='1')
 order by YYSJ00,a.XH0000  
) where nvl(BRXM00,' ')<>' ' 

6       15:12:09  SQL Data In: ORACLE - Param = 1, Name = PAPPLYNO, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 13804719
7       15:12:09  SQL Data In: ORACLE - Param = 2, Name = PPATLOCALID, Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
8       15:12:09  SQL Data In: ORACLE - Param = 3, Name = PQUEUENO, Type = fldZSTRING, Precision = 3, Scale = 0, Data = 004
9       15:12:09  SQL Data In: ORACLE - Param = 4, Name = PSUCC, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
10      15:12:09  SQL Execute: ORACLE - BEGIN "P_PACS_CANCEL" (PAPPLYNO => :PAPPLYNO,PPATLOCALID => :PPATLOCALID,PQUEUENO => :PQUEUENO,PSUCC => :PSUCC); END;
11      15:12:09  SQL Error: ORACLE - ORA-06550: 第 1 行, 第 7 列: 
PLS-00201: 必须声明标识符 'P_PACS_CANCEL'
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored

12      15:12:09  SQL Error: ORACLE - Unmapped SQL Error Code: 6550