# Toad insight, Public synonyms

**URL:** <https://forums.toadworld.com/t/toad-insight-public-synonyms/39779>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [July 31, 2017, 6:27am UTC](https://forums.toadworld.com/t/toad-insight-public-synonyms/39779 "2017-07-31T06:27:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![frank.diedrich](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@frank.diedrich](https://forums.toadworld.com/u/frank.diedrich)\
**Post date:** [July 31, 2017, 6:27am UTC](https://forums.toadworld.com/t/toad-insight-public-synonyms/39779/1 "2017-07-31T06:27:18Z")

</div>

Hi,

i am facing following issue (Version 12.11):

Schema DEV

Package TEST with procedure PROC, public synonym TEST

Package DBMS\_OUTPUT, schema SYS

1. Case with Toad insight objects Public synonyms unchecked:

In Editor:

Typing TEST and Strg+. gives picklist TEST package

Typing TEST. and Strg+. gives picklist PROC

Typing DBMS\_OUTPUT and Strg+. gives picklist empty

Typing SYS.DBMS\_OUTPUT and Strg+. gives picklist DBMS\_OUTPUT synonym

That result is expected

1. Case with Toad insight objects Public synonyms checked:

In Editor:

Typing TEST and Strg+. gives picklist TEST package and synonym

Typing TEST. and Strg+. gives picklist empty

Typing DEV.TEST. and Strg+. gives picklist PROC

Typing DBMS\_OUTPUT and Strg+. gives picklist DBMS\_OUTPUT synonym

Typing DBMS\_OUTPUT. and Strg+. gives picklist all element from DBMS\_OUTPUT

That result is unexpected for schema DEV.

Maybe there are some issues in gathering the data for the picklist.

BR Frank

---

<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:** [July 31, 2017, 6:54am UTC](https://forums.toadworld.com/t/toad-insight-public-synonyms/39779/2 "2017-07-31T06:54:20Z")

</div>

Thanks, I've logged and can reproduce.

> Maybe there are some issues in gathering the data for the picklist.

My guess is that it's the pick list filtering incorrectly hiding PROC since the package and synonym are located and shown in your prior step. I'll take a look.

Michael

---

<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:** [July 31, 2017, 8:00am UTC](https://forums.toadworld.com/t/toad-insight-public-synonyms/39779/3 "2017-07-31T08:00:38Z")

</div>

This boiled down to a case of too much hand holding. When multiple possibilities exist having the same name Code Insight would show nothing.

I changed it to drill into the first item it can find in the list matching what you’ve typed. If it guesses incorrectly you can always force the object you want by selecting it from the pick list and then typing period. At least this way something will be shown, always, and the guess will be right at least some of the time. 🙂 This is in place for next beta.

Michael