2 Replies Latest reply on Jan 10, 2018 9:45 PM by Vadim Tropashko-Oracle

    Syntax error for "fetch first <bind var> rows only" in cursor

    Menno Hoogendijk

      Hi,

       

      I created this valid cursor in 12c.

       

      Knipsel.PNG

      But SQL Developer 17.4 gives a syntax error if you use a variable to fetch the first n rows.

       

      Knipsel.PNG

       

      Versions:

      SQL Developer: 17.4.0.355

      OS: Windows 10 - 64-bit