I haven't experience with ORACLE (a work with SQL Server).
I have to do it:
1.write function/procedure in ORACLE that get XML as parameter.
2.parsing this XML parameter in order to get any value and use these
values for "where conditional " in SQL (SELECT * FROM ... WHERE ...).
3.return result as xml.