Code analysis: Wrong 5406 (unused parameters) with aggregate functions

Toad for Oracle - Beta
1

The input parameter is marked with “Remove unused parameters or modify code to use the parameter.” in the STRAGG function (by Tom Kyte). Aggregat functions cannot “use” their parameters.

create or replace function stragg
( input varchar2 )
return varchar2
deterministic
parallel_enable
aggregate using stragg_type
;

2

That’s very true indeed. We overlooked that. Will fix asap. (QP-2103)

Thanks,
Andre

3

Now in Q5.dll version 5.307, which you’ll see soon in Toad.

Thanks,
Andre

4

I am now at TOAD 12.11.0.31 and my qp5.dll has Version 5.307, but I still see this warning.

5

I now am at TOAD 12.11.0.31 and my qp5.dll has Version 5.307, but I still see this warning.

6

You need the latest RuleUniverse.xml to accompany the latest QP5, but there was a slight hiccup in distributing it. I’ll make sure that it is included in the next beta.

Michael

7

It’s in 12.11.0.37.