Toad World® Forums

Formatter 317 advice problem


#1

Hi

At least with 317 advice I have this problem (but maybe it occurs with others)
if the line size is near the 80 we get from

where
DBMS_LOB.
getlength (‘dddddddaaaa’) > something

this

where
DBMS_LOB.
/*ADVICE(9): Functions with constant parameters in WHERE clause [317] */
getlength (‘dddddddaaaa’) > something

i.e. the advice gets in the middle of the package.procedure

Test code:

SELECT 1
FROM DUAL
WHERE ( ( ( ( ( ( ( ( ( ( ( ( (DBMS_LOB.getlength (‘aaaa’) >
/*ADVICE(3): Functions with constant parameters in WHERE clause [317] */
( ( ( ( (DBMS_LOB.
/*ADVICE(5): Functions with constant parameters in WHERE clause [317] */
getlength (‘dddddddaaaa’)))))))))))))))))))

I think that the main problem is the cut on package.procedure due to the columns limit and then the advice gets in the line below the first char of the “problem” and not from the line of the last char.

Regards
Filipe


#2

Hi Filipe,

I have created a CR for this. But I’m afraid this also has to wait till the new advisor engine completes to be fixed.

Thanks,
Vincent