User defined reports in SQL Dev that reference the same named bind value multiple times prompts for each occurance of the bind value. Only one prompted (the last?) value is used.
The following query when run from a SQL worksheet correctly prompts for the bind value only once and, however, when turned into a report it prompts for the bind value twice:
SELECT * FROM dual WHERE dummy = :VALUE OR dummy || dummy = :VALUE