帮我看看这个错误,烦恼啊
请看我下面的语句:
myResultSet=myStatement.executeQuery("select XMMC,XMGS from PROJECT where EXISTS (select * from MY_CURR_PROJECT where PROJECT.XMBH=XMBH AND USER_ID="+"\'"+UserID+"\'");
该语句执行后,系统报该错误:java.sql.SQLException: [BEA][Oracle JDBC Driver][Oracle]ORA-00907: missing right parenthesis
这是我这条语句的输出:select XMMC,XMGS from PROJECT where EXISTS (select * from MY_CURR_PROJECT where PROJECT.XMBH=XMBH AND USER_ID='null')
我把这条语句在SQL*PLUS上执行是正确的,为何这里总是提示我缺少右括号?
数据库用的oracle9i