Does ODAC have substitution params???
example
select
name,
address
:P_PHONE
from
users
result if :P_PHONE is null
name | address
---------|---------------------
John | Address 1
Susan | Address 2
result if :P_PHONE = 555
name | address | 555
---------|---------------------
John | Address 1 | 555
Susan | Address 2 | 555
or
select * from users
where name :P_NAME 'John'
then :P_NAME can be =, , like ...