2 Replies Latest reply: Feb 6, 2014 2:54 PM by Barry Mcgillin-Oracle RSS

    SQL Worksheet. Missing IN or OUT parameter at index:: 1

    user11982730

      12C pattern matching allows question sing ? without quotes. This sample works in SQL*Plus:

      SQL> l

        1  select *

        2  from dual

        3  match_recognize (

        4    order by dummy

        5    measures

        6       dummy as x

        7    pattern (z?)

        8    define

        9       z as 1=1

      10* )

      SQL> /

       

      X

      -

      X

       

      I cannot execute same query in SQL Developer 4.0:

      Missing IN or OUT parameter at index:: 1