Toad insight, Public synonyms

Toad for Oracle & DevOps Toolkit
1

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

2

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

3

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. :slight_smile: This is in place for next beta.

Michael