8 Replies Latest reply on Dec 18, 2018 5:45 PM by rp0428

    Does the parser not support deprecated language keyword "THE" in legacy code? There is a workaround, but...

    user2885917

      The code below is compiled and executed in Oracle Database 18c (18.3),

      but the parser cannot parse it. Probably a problem in the "THE" keyword.

      This is a problem if you have a lot of legacy code that already uses such keywords.

      But there is a workaround - use keyword "TABLE" instead.

       

      Can the grammar rules be extended to support legacy code?

       

       

      create or replace type t_integers_tab as table of number

      /

       

      declare

        v_tab_int t_integers_tab := t_integers_tab(1);

        v_counter integer;

      begin

       

        select sum(column_value)

          into v_counter

          from the (select cast(v_tab_int as t_integers_tab) from dual);

       

        dbms_output.put_line(v_counter);

       

      end;

      /