# Explain plan bug

**URL:** <https://forums.toadworld.com/t/explain-plan-bug/38375>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 14, 2016, 10:41pm UTC](https://forums.toadworld.com/t/explain-plan-bug/38375 "2016-09-14T22:41:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [September 14, 2016, 10:41pm UTC](https://forums.toadworld.com/t/explain-plan-bug/38375/1 "2016-09-14T22:41:53Z")

</div>

Toad 12.9.0.71 (but saw this problem before as well).

1. Start query (F9) in editor (no selection at all, sql determined with ";"
2. while SQL is running (sometimes saw that even SQL finished), I click on the plan button
3. Somehow toad select first word and report an error  
 ![4721.Unbenannt.jpeg](https://global.discourse-cdn.com/quest/original/2X/7/7fc7caa548391cb592ab3492776c85fe06880837.jpeg)

- from that moment whenever I try to get plan-error is the same
- then I edited the query and put all in one line and "Explain plan" works again  
 ![7444.Unbenannt2.jpeg](https://global.discourse-cdn.com/quest/original/2X/1/13f839631f9eb8bee40f71fed1c52e51db28a9fb.jpeg)

but couldn't reproduce this bug all the time.

Bug is present on 11 and 12 databases so I think it is something related to "internal" Toad parsing and manipulating with SQL text.

Brg

Damir
