Re: Code Analysis Rule 6405
Gregory Liss <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Thanks for the example. This is one of our "legacy" rules that we're in the process of converting to the new technology. This one (and several others) require quite a bit of work to get converted and the team is cranking them out as fast as possible. I'll let you know when they're fixed.
Greg
On Jun 27, 2012, at 10:42 PM, chuckoneal99 wrote:
> It only flags line 3 "a VARCHAR2 (1);", not all 3 lines.
>
> CREATE OR REPLACE PROCEDURE x
> AS
> a VARCHAR2 (1);
> b PLS_INTEGER;
> c PLS_INTEGER;
> BEGIN
> DBMS_OUTPUT.put_line ('-');
> END;
>
> rule 6405: Avoid defining variables that are not referenced inside the program. - [Program Structure, Variable, Information] (3: 4)
>
> --- In [email protected], Gregory Liss <gregory.liss@...> wrote:
>>
>> Do you have a short code example where this is happening?
>>
>>
>>
>>
>> On Jun 27, 2012, at 4:27 PM, "chuckoneal99" <chuckoneal99@...> wrote:
>>
>>> Can this be changed to find all of the violation vs stopping on the first hit? In an earlier life it would report all.
>>>
>>>
>>>
>>> ------------------------------------
>>>
>>> Yahoo! Groups Links
>>>
>>>
>>>
>>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/