Code Pop-ups on tables assessed with synonyms

Toad for Oracle
1

I’ve noticed this issue for a while – including earlier versions of
Toad – and thought I’d send out an e-mail to see if this is a feature
enhancement request or if I’m just missing a setting within the
Toad/Oracle IDE. I’m currently on 10.1.1.8 of the Toad for Oracle
Professional IDE.

Here’s the issue, when I type a sql statement this way:

SELECT t.
FROM scott.emp t

The “t.” piece, will eventually display a pop-up list of the columns
within the scott emp table. I love that! Very useful, especially
with wide tables.

Now if I have a public synonym defined for scott.emp and I’m not
logged into the Scott schema and I enter this:

SELECT t.
FROM emp t

the pop-up list of columns is not displayed after I enter the “t.”.
Why is that? Is it a bug/feature request or a switch I need to set?

An unrelated comment. I’ve been working with getting Harvest to work
with Toad. The Toad version 10 SCC interface to Harvest is much
improved. Thank you. It’s not perfect but I’m now under the
impression that most of these issues are within Harvest.

–
Rumpi Gravenstein

2

I’ve noticed it too. Even Shift+Ctrl +T does essentially nothing.
Mentioned here and to Support, though not with the extra info you provide. No
luck.

9.7.2.5 here

Guess we’re the only two to whom it’s happening.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg

3

I just tried this in the beta with a public syn like dba_tables and it works

Can you make sure you have synonyms enabled in the code insight options? The
public ones are disabled by default to the vast amount of them in some databases
and the memory consumption that results

4

That does the trick for me. THANKS MUCH. J

I don’t recall having to change such a setting in the past; has the
default changed?

I don’t know enough to detect the difference, but I’d guess we
access most of our Banner tables by their synonyms.

Thanks again,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg

5

I’m pretty sure the editor insight feature didn’t work at all for
syns before 9.7. When it was added, it was made optional, not on by default.

There’s a secondary option to cache the objects into memory when they are
loaded, you might want to experiment with that if you have performance issues.
image001.jpeg