1       16:54:37  Log started for: 库存物资管理子系统
2       16:54:48  SQL Execute: ORACLE - select distinct DBGRIN from XT_ZDYLXS where YGBH00=369 and BMBH00=34
 and DLXTMC='库存物资管理子系统' and CTMC00='frmWZ_DBDRKCX'

3       16:54:48  SQL Execute: ORACLE - SELECT * FROM BM_WZSX00 ORDER BY WZSXBH

4       16:54:48  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 34.000000
5       16:54:48  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 
6       16:54:48  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120417
7       16:54:48  SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120417
8       16:54:48  SQL Execute: ORACLE - SELECT RCKDH0,BMMC00,RCKBMC,KDRQ00,CGYGXM,BZ0000,RCKID0,KFBMBH,QRRQ00,FHBMMC
FROM VW_WZ_RCK000  WHERE 
rckid0 in (select distinct b.RCKID0  FROM VW_WZ_RCK000 a,VW_WZ_RCKMX0 b,bm_wzdm00 c where a.RCKID0=b.RCKID0 and c.WZDMID =b.WZDMID  
 and a.KFBMBH = ? AND a.RCKLB0 ='1' and c.WZDMBM||'' like ? ||'%'
 AND a.QRRQ00 >=? AND a.QRRQ00 <=?
and b.BZSL00<>'0' 
 and a.RCKLX0='35' 
  order by RCKDH0 desc

9       16:54:48  SQL Error: ORACLE - ORA-00907: 缺失右括号

10      16:54:48  SQL Error: ORACLE - Unmapped SQL Error Code: 907
11      16:54:48  SQL Data In: ORACLE - Rows affected = 0