# Missing navigator

**URL:** <https://forums.toadworld.com/t/missing-navigator/50973>\
**Category:** Toad for Oracle - Beta\
**Created:** [September 14, 2020, 6:45pm UTC](https://forums.toadworld.com/t/missing-navigator/50973 "2020-09-14T18:45:16Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 14, 2020, 6:45pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/1 "2020-09-14T18:45:16Z")

</div>

When opening a package body from the editor and clicking a p\_package\_name, without a function name, the navigator is blank and takes a few minutes to respond. With a function name it works ok ,but still take some time.

 ![image](https://global.discourse-cdn.com/quest/original/2X/6/6e6680110e38d472f62f36a4793e9aaa5e241153.png)

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 16, 2020, 8:30pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/2 "2020-09-16T20:30:07Z")

</div>

It happened again, attached is the output file. I went into sql editor, pasted  
"P\_TRADE.SELECT\_TRADE\_BY\_ID", double clicked on the procedure name. Toad hung for 5 minutes and then came back to life. I checked out the log file, thinking maybe the db was slow, but all queries are under a second. The screen was flickering during this time, but i had no control.

not sure why, but there is a 3 minute gap  
 ![image](https://global.discourse-cdn.com/quest/original/2X/5/5f3d481f7cffc43c9a73741504acd8f520b2d0de.png)

[toad.txt](https://forums.toadworld.com/uploads/short-url/yGuCxtFb4GXKN56ugQljDTNy5bd.txt) (39.3 KB)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 16, 2020, 8:50pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/3 "2020-09-16T20:50:50Z")

</div>

Could it be that your connection was timed out? I know you didn't get any "connection lost" type message but that's what it sounds like.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 17, 2020, 12:59pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/4 "2020-09-17T12:59:25Z")

</div>

I can recreate the issue ever time in beta14. I just tested beta14 and 13.2 side by side. 13.2 takes 10 seconds, while beta can take 3-5 minutes. The queries look the same in both environments, what can i check for next?

[beta.txt](https://forums.toadworld.com/uploads/short-url/c7lEVXn5Pq6nW6LtpCQrvwhrWsJ.txt) (3.3 KB) [toad132.txt](https://forums.toadworld.com/uploads/short-url/Pb5VPo5YVUQUqUF7ecGvMYYNHu.txt) (3.0 KB)

[ToadBetaini.txt](https://forums.toadworld.com/uploads/short-url/uhbRboyLDWnHdvHcSXYbzC02ro1.txt) (24.6 KB) [Toad13ini.txt](https://forums.toadworld.com/uploads/short-url/o4c8P4o2WAKe4u1TNvj4Qptu25M.txt) (22.0 KB)

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [September 17, 2020, 1:04pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/5 "2020-09-17T13:04:37Z")

</div>

I'm not quite following you on how you reproduce this. Can you reproduce the long delay just by opening your package from the Editor's Load from Database window? At that point the Editor should parse the text and then load the Navigator. Is that slow, too, or is the double clicking you mentioned earlier required? Can you share your package code as well? I'll send you a direct message with my email address if you can send me the code and detailed steps to reproduce it.

Thanks,  
Michael

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 17, 2020, 1:27pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/6 "2020-09-17T13:27:58Z")

</div>

I am also able to repro this using my local db on my desktop. Most of the network latency is removed and still have the issue.

Found the original issue. When I double click the package from the schema browser, the package opens and i can work on the package, but the navigator is empty for 2 minutes(toad is not frozen). When I click from sql editor toad **is frozen** , until the navigator comes back.

steps to repro

open sql window  
paste P\_TRADE.SELECT\_TRADE\_BY\_ID  
double click on P\_TRADE.SELECT\_TRADE\_BY\_ID

I will send you the package in the email.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 17, 2020, 1:30pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/7 "2020-09-17T13:30:41Z")

</div>

here is the package. thanks

(Attachment p\_trade.pks is missing)

(Attachment p\_trade.pkb is missing)

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 17, 2020, 1:50pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/9 "2020-09-17T13:50:12Z")

</div>

You can skip all the loading from the db, I just pasted the package body code into the editor and it took 2 minutes for the navigator, Toad did not freeze, but the navigator took 2 minutes to draw.

to repro:  
I took the body code i emailed you and pasted into the editor.

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [September 17, 2020, 2:05pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/10 "2020-09-17T14:05:33Z")

</div>

Thanks for your code. I can reproduce it and will log this defect. You have 2 options as a workaround...

1. If you do not use Code Analysis, disable it by unchecking "Check Rules as you type" on the "Code Analysis | General" page in Toad's Options.
2. If you use Code Analysis you can copy the RuleUniverse.xml from your prior Toad install folder and replace the one in your beta folder with the older. Do this with Toad closed. You will need to do this every time you install a newer beta update.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 17, 2020, 2:11pm UTC](https://forums.toadworld.com/t/missing-navigator/50973/11 "2020-09-17T14:11:44Z")

</div>

Thank you, I chose #1. I usually run this manually. THANKS!!!!
