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;
/