java.sql.SQLException: ORA-00907: missing right parenthesis
为什么显示缺少右括号啊?我怎么找都找不到?
public String reptSpReclaimCompar2() {
vtwegList = vbakpManager.getVtwegList();
if (!"1".equals(dosearch)) return SUCCESS;
vtwegList = vbakpManager.getVtwegList();
if (!"1".equals(dosearch)) return SUCCESS;
AllUsers user=getAllLoginInfo();
String usId = user.getLoginId();
String vbkursOfUser = "";
String vtwegsOfUser = "";
if (!"1".equals(user.getHqSign())) {
vbkursOfUser = vbakpManager.getVbkursOfUser(usId);
vtwegsOfUser = vbakpManager.getVtwegsOfUser(usId);
}
this.pageList = reptManager.reptSpReclaimCompar2(user.getHqSign(), vbkursOfUser, vtwegsOfUser, vtweg, vkbur, kunnr, beginDate, endDate);
return SUCCESS;
}
------解决方法--------------------------------------------------------
执行的SQL语句有语法错误,
你去找一下是哪个地方的SQL有问题。