2 Replies Latest reply: Feb 6, 2014 12:54 PM by Barry McGillin RSS

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

user11982730 Newbie
Currently Being Moderated

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