Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

2907631Dec 17 2018 — edited Dec 18 2018

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;

/

This post has been answered by thatJeffSmith-Oracle on Dec 18 2018
Jump to Answer

Comments

Post Details

Added on Dec 17 2018
8 comments
205 views