I seem to remember that oracle is evaluating both sides of OR in where clause.
select a,b from c where a =1 and (:v1 is null or function(:v1) = b); Is the function activated when :v1 is null? -- Adar Yechiel Rechovot, Israel -- //www.freelists.org/webpage/oracle-l