3 Replies Latest reply on Jul 15, 2015 5:42 PM by ERPDude

    OSD 4.1.1.19 no longer processing substitution prompts the same

    ERPDude

      Hi guys...

       

      I noted in the bug fixes for OSD 4.1.1.19 that they fixed a bug with how OSD handles prompts.

      Bug 21113822INCORRECT PROMPT BEHAVIOR WITH SQL DEVELOPER; "SUBSTITUTION CANCELLED"

      I have found that my scripts that include prompts within a string literal are no longer working.

       

      Old SQL that was working in 4.1.0.x

      select 'x' from dual where '&value' = 1;

       

      The only way I have found to make it work is to code it this way;

      select 'x' from dual where :value = 1;

       

      Is this just how OSD will be working from now on or is this a new bug?

       

      Thanks...

       

      Tom