java.sql.SQLException: ORA-01036: illegal variable name/number

[san krish]

I am trying to change an existing SQL statement and adding order by clause with Asc or Desc keyword. My query looks like this...

...///

WHERE rank BETWEEN #{startrow} AND #{endrow}
<if test="sort != null and sort != ''">
order by #{sort} #{direction}
</if>
....///

When I do not sort in the UI the query works fine. However if I sort on any fields in UI i get

### Error querying database. Cause: java.sql.SQLException: ORA-01036: illegal variable name/number
### Cause: java.sql.SQLException: ORA-01036: illegal variable name/number

; uncategorized SQLException for SQL []; SQL state [72000]; error code [1036]; ORA-01036: illegal variable name/number
; nested exception is java.sql.SQLException: ORA-01036: illegal variable name/number


I can see proper values getting passed from my controller to mapper class and the xml file. Can someone help me with this please?

[chris webster]

Can you show us the actual SQL statement that Oracle is receiving from this code? Because the error is being raised by the Oracle database, so you need to know what SQL Oracle is actually looking at.