关于sql在navicat执行没问题,在mybatis中执行提示sql语句未正确结束的问题(oracle数据库)

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

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

<select id="getByName" resultMap="BaseResultMap" parameterType="string">
    select
    <include refid="Base_Column_List"></include>
    from
    <include refid="Table_Name"></include>
    where login_name = #{loginName} and status='0';
</select>

去掉上图sql结果的分号";"后问题解决了.