How about this :

SELECT ......
FROM mytable
WHERE field1 = nvl(param1, field1)
AND field2 = nvl(param2, field2)
AND field3 = nvl(param3, field3)


the trick is : if the param is empty, compare the database field with itself.

HTHs,
Chiappa