5 Replies Latest reply on Oct 4, 2016 12:42 PM by Raj Jamadagni

    [4.2EA1] - Repeated bind variable in user written report is mishandled in prompts

    Brad Peek

      Condition: A user written report contains a SQL statement with the same bind variable name more than once.


      Error:  When the report is executed, the pop-up window that prompts for bind variable values contains each instance of the bind variable separately.  So, if a bind variable named :TABLE_OWNER occurs three times in the SQL statement then it is shown three times in the pop-up window that prompts for values.


      From v4.2[ea1]


      From v4.1.5 (and earlier)


      You can see also that the text associated with the bind variable that is part of the prompt only appears in version 4.1.5 (and earlier) but not in the 4.2 EA1.