1       11:53:29  SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
2       11:53:29  SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 002757
3       11:53:29  SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
4       11:53:29  SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
5       11:53:29  SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
6       11:53:29  SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
7       11:53:29  SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
8       11:53:29  SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
9       11:53:29  SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL
10      11:53:29  SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
11      11:53:29  SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
12      11:53:29  SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
13      11:53:29  SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
14      11:53:29  SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      11:53:29  SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
16      11:53:29  SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END;
17      11:53:29  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 002757      
18      11:53:29  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.000000
19      11:53:29  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.000000
20      11:53:29  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 97.000000
21      11:53:29  SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150501
22      11:53:29  SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20150513
23      11:53:29  SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00,
XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,CXSL00,
DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00,
KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00,
APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00,
ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID,
YPNM00,JGZCBZ,DCBZ00,TQPC00,CXDJH0,ZJE000,YJLRBZ,
BZ0000,KDBQ00,CH0000,NL0000,BQSFBZ,
(select czyxm0 from zy_brfy00 m where b.sfdjh0=m.djh000) czyxm0  from VW_BQ_YJYW00 b
where xmzt00 not in('7') and ZYHGHH=?
 and yjlrbz='N' 
 and (kdksbh  in (select  ksh000 from bm_bqks00 where bqh000=?) or b.KDBQ00=?) 
 and zlxmid<>0 
 and (  (yjksbh =0) 
  or ZLXMID in (Select ZLXMID FROM BQ_HZYZXMST ) 
  or not exists(select ' 1 ' from bm_bmbm00 m where m.bmbh00 = b.yjksbh and m.bmxz00 = ' 5 ' and b.xmzt00 in (' 3 ', ' 4 '))) 
 and  xmzt00<>'6' and SL0000-nvl(CXSL00,0)>0
and ((not exists (select '1' from YJ_YW0000 a Where a.yjdjh0=b.yjdjh0 and (a.XMZT00 in ('3','4') or a.ZXSL00>0)  and a.YJKSBH not in (select ksh000 from bm_bqks00 where bqh000=?)) 
  or ZLXMID in (Select ZLXMID FROM BQ_HZYZXMST ) ))
 and kdrq00 between ? and  ?
 order by yjdjh0

24      11:53:29  SQL Error: ORACLE - ORA-01427: 单行子查询返回多个行

25      11:53:29  SQL Error: ORACLE - Unmapped SQL Error Code: 1427
26      11:53:29  SQL Data In: ORACLE - Rows affected = 0