Toad World® Forums

Formatter advice 317


#1

Here is the code

DECLARE
TYPE arr IS TABLE OF VARCHAR2 (80)
INDEX BY PLS_INTEGER;

l_arr   arr;
li      PLS_INTEGER;

BEGIN
l_arr (1) := ‘0’;

SELECT 1
  INTO li
  FROM DUAL
 WHERE l_arr (1) = 0;

/*ADVICE(13): Functions with constant parameters in WHERE clause [317] */
END;

If there any change that in the future this advice will figure out that it’s not calling a function but a “table of”?

Thanks
Filipe