1 Reply Latest reply on Aug 20, 2020 4:40 PM by thatJeffSmith-Oracle

    Missing IN or OUT parameter at index:: 1

    Mike Kutz

      SQL*Developer 20.1

      DB: ATP Free Tier (19c)

       

      I don't know if this is a known bug or not.  But, I'll figured I'd post up my test-case to see if it is me or something else.

       

      I was trying to insert a large text string using the q'[]' notation.  Normally, that works.

       

      But, with one particular string, I got this error: "Missing IN or OUT parameter at index:: 1".

       

      I narrowed the problem down to this string format failing:

      select q'[]]:a]'
      from dual;
      

       

      The 'a' can be any alpha-numereic.  Although, I haven't tried everything.

      It seems there can be an arbitrary amount of extra characters between every thing except the two closing square brackets

      eg: this still fails

      select q'[ ]] :  a   ]'
      from dual;
      

      Which causes this regex string to fail

      select q'[[[:digit:]][[:alpha:]]]'
      from dual;
      

       

      WORKAROUND

      use q'{}' syntax ( curly brackets) instead. Actually, anything BUT square brackets. even q'z]]:a]z' works.

       

      Thanks

       

      MK