Error querying database. Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

The error may exist in file [D:\SVN\SCM\demoproject\target\classes\mappers\MaterialUpdateMapper.xml]

The error may involve defaultParameterMap

The error occurred while setting parameters

SQL: SELECT BILLID FROM SCM_MaterialUpdateListAHead documentnumber = ?

Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
] with root cause
java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束

public interface MaterialUpdateMapper {
int SaveHead(SCM_MaterialUpdateListAHead user);
int GetBillId(String documentnumber);
int SaveItems(SCM_MaterialUpdateListA3 items);
}

<select resultType="int">
SELECT BILLID   FROM SCM_MaterialUpdateListAHead   documentnumber = #{documentnumber}
</select>

回答

标准sql select billid from table where documentnumber = #{documentnumber};