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...


      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




        v_tab_int t_integers_tab := t_integers_tab(1);

        v_counter integer;



        select sum(column_value)

          into v_counter

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