Re: TOAD doesn't like FOR statement?

Michael Moore <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <CACpWLjO_DfZWp5Bexr1=7s0hNR104MjGKkeM+-hfsCpzS0tpvw@mail.gmail.com>
I had to turn it off. It became too annoying especially during the
development phase when things are generally a mess. When I'm all done
coding, I use  Code Analyzer. Also, many of the rules are problematic. For
example:

      c_aff_key_username_nomatch     CONSTANT PLS_INTEGER := -20013;
      aff_key_username_nomatch                EXCEPTION;
      PRAGMA EXCEPTION_INIT (aff_key_username_nomatch, -20013);

It tells me that aff_key_username_nomatch is not referenced when it is
referenced in the very next line.

Still, it DOES catch problems, so I do use it while wishing it was smarter.
:-)

Mike


On Mon, Oct 10, 2011 at 1:18 PM, Gregory Liss <[email protected]>wrote:

> **
>
>
>  We don't have a "ignore this rule" or "ignore this instance" feature
> yet…yet.   That sounds like a good one for the Idea Pond!****
>
> ** **
>
> *From:* [email protected] [mailto:[email protected]] *On Behalf Of *Wendy
> Penfold
> *Sent:* Monday, October 10, 2011 03:59 PM
> *To:* [email protected]
> *Subject:* Re: [toad] TOAD doesn't like FOR statement?****
>
> ** **
>
> Cool...I'm not getting the mouse over, but I can right click and see the
> rule violation.  Is there anyway I can get the blue squiggles to turn off
> once I've reviewed it without turning the feature off entirely?
>
> On 10/10/2011 3:35 PM, Gregory Liss wrote: ****
>
>   ****
>
> It's not that it doesn't like it.  Well it kind of doesn't like it.  That's
> the new Code Analysis feature.  If you mouse over the blue squiggles, it'll
> show you what rule has been violated.  Also, if you right click on the blue
> squiggles, you'll see a menu item or Rule Violations and you can get a
> detailed explanation of what it doesn't like.  The blue squiggles don’t
> affect the ability to compile but do show you some possible issues in the
> "best practices" world.****
>
>  ****
>
> Greg****
>
> (squiggle dumb).****
>
>  ****
>
> *From:* [email protected] [mailto:[email protected]<[email protected]>]
> *On Behalf Of *Wendy Penfold
> *Sent:* Monday, October 10, 2011 02:54 PM
> *To:* ToadList
> *Subject:* [toad] TOAD doesn't like FOR statement?****
>
>  ****
>
> Hi, I just upgraded to 11.0.0.116 and Toad seems to not like the FOR
> statement in this proc...although the package compiles ok.
>
> ****
>
>  
>
image001.png (image/png, 13.6 KB) - not displayed
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.