"CONTAINS" not working in View Criteria

Question

I have created a View Criteria in ADF that searches employees on the basis of employee name and name is passed through a bind variable. When I search using equals it fetches the result.

However, my requirement is to search using CONTAINS. When I use CONTAINS it doesn't fetch out any data and shows no record found.

Answer 1

This error was occurring because i was querying MySql but syntax which was gong through here was of ORACLE , so what we can do here is change the query execution mode from database to in memory this will resolve the error and will work fine and it worked for me.