Chris,
In the Oracle i don't have problem for do it. In our case it's used consults(queries) REST and not PL/SQL Oracle statement.
Remember, all consults(queries) in the ArcGIS Server are made for REST services.
So, i need of a statement or config(ArcGIS Server or application) for searching Accent Insensitive in services REST.
Thanks! (: