Toad World® Forums

Qualified expression syntax highlighted as incorrect

Howdy,

In 14.1.96.896 (update hasn't come through for me yet), I have code similar to this from https://blogs.oracle.com/oraclemagazine/easy-initializing-for-records-and-arrays:

DECLARE
   TYPE ints_t IS TABLE OF INTEGER
      INDEX BY PLS_INTEGER;

   l_ints   ints_t := ints_t (600 => 55, -5 => 555, 200000 => 5555);
   l_index pls_integer := l_ints.first;
BEGIN
   WHILE l_index IS NOT NULL
   LOOP
      DBMS_OUTPUT.put_line (l_index || ' => ' || l_ints (l_index));
      l_index := l_ints.NEXT (l_index);
   END LOOP;
END;
/

Toad highlights the first "=>" as a syntax error, but it works fine in Oracle 19.6 (and probably down to 18 as well).

Thanks!
Rich

Hi Rich,

I've verified this issue and created a Jira item for our parser team to take a look at it and add support for qualified expressions. We'll get this addressed as soon as we can.

Thanks for letting us know about this!

-John

1 Like