0 Replies Latest reply on Sep 23, 2016 3:29 PM by Sentinel

    [4.2EA] Reports prompt for the same Bind value multiple times.


      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