0 Replies Latest reply on Jan 31, 2014 6:53 AM by Arpod

    [4.0] PL/SQL editor: Run and Debug - escaping single quote in parameters

    Arpod

      When I use 'Run' or 'Debug' buttons from PL/SQL editor and fill out varchar2 parameter with a string containing a single quote ('), it is automatically escaped with another single quote once I press enter, making it (''). However, if I modify the parameter once more, each quote is escaped again and becomes (''''), then ('''''''') and so on. Moreover, the same thing happens even if I modify another parameter.