# Code Analysis: "5406 Remove unused parameters" when used in sub query

**URL:** <https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991>\
**Category:** Toad for Oracle - Beta\
**Created:** [July 8, 2016, 1:02am UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991 "2016-07-08T01:02:36Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![PeterLang](https://avatars.discourse-cdn.com/v4/letter/p/71e660/32.png) [@PeterLang](https://forums.toadworld.com/u/PeterLang)\
**Post date:** [July 8, 2016, 1:02am UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991/1 "2016-07-08T01:02:36Z")

</div>

in\_dummy is marked with “5406 Remove unused parameters or modify code to use the parameter.”

CREATE OR REPLACE PROCEDURE prc(  
in\_dummy IN dual.dummy%TYPE  
)  
AS  
v\_dummy dual.dummy%TYPE;  
BEGIN  
SELECT CASE WHEN EXISTS( SELECT 1 FROM dual WHERE dummy = in\_dummy ) THEN dummy END  
INTO v\_dummy  
FROM dual;  
END prc;

---

<div class="post-metadata">

**Author:** ![PeterLang](https://avatars.discourse-cdn.com/v4/letter/p/71e660/32.png) [@PeterLang](https://forums.toadworld.com/u/PeterLang)\
**Post date:** [July 29, 2016, 12:10am UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991/2 "2016-07-29T00:10:02Z")

</div>

Did you get this?

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [July 29, 2016, 4:24am UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991/3 "2016-07-29T04:24:52Z")

</div>

Yep, I logged this together with your Jul 19 post [http://www.toadworld.com/products/toad-for-oracle/toad\_for\_oracle\_beta\_program/f/86/t/31085](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/31085) .

Thank you anyway for your feedback, please keep on posting new findings. But unfortunately we can’t fix them as quickly as you can post … 🙂

---

<div class="post-metadata">

**Author:** ![PeterLang](https://avatars.discourse-cdn.com/v4/letter/p/71e660/32.png) [@PeterLang](https://forums.toadworld.com/u/PeterLang)\
**Post date:** [July 31, 2016, 11:27pm UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991/4 "2016-07-31T23:27:32Z")

</div>

I’m usually impressed by the time it takes you to fix things 😉

Just wanted to make sure that you got this one too.

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [November 17, 2016, 8:44am UTC](https://forums.toadworld.com/t/code-analysis-5406-remove-unused-parameters-when-used-in-sub-query/37991/5 "2016-11-17T08:44:29Z")

</div>

This has been addressed, soon to show up in a new Toad having QP5 version 5.305 (or later).  
In addition, the following issues were detected and fixed:

- Nested variable declarations and parameter declarations in nested program units or cursors are taken into account.,
- Items in select lists are no longer discarded,
- In qualified names now only the leftmost identifier is taken into account.  
Thanks,  
Andre