2 Replies Latest reply on Dec 20, 2018 8:05 PM by user2885917

    Parser can not parse the correct code:{ UPDATE ... RETURNING ... INTO v_tab(1) } Problem with parsing?

    user2885917

      The code below is compiled and executed in Oracle Database 18c (18.3), but the parser cannot parse it.

      Is this some kind of problem with parsing?

       

      create table t

      (

      n1 number,

      n2 number

      )

      /

       

      declare

        type t_tab is table of number index by binary_integer;

        v_tab t_tab;

        v_n1  number;

      begin

       

        update t

           set n1 = 1,

               n2 = 2

        returning n1, n2 into v_n1, v_tab(1);

       

      end;

      /

       

      parser_syntax_error_4.png