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/
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.