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