After connecting to the database in SQL Navigator, the Object Explorer window show zero items for all object types. When expanding objects in the window an error appears, "Data type is not supported."
Querying objects manually in the editor works fine.
See Screen Shot: No Objects in DB Explorer.jpg
SOLUTION 1:
Connect to the Oracle database with a 9i Oracle Client or higher.
SOLUTION 2:
Reset SQL Navigator preferences in registry:
1. Close SQL Navigator.
2. Go to the registry (Start | Run and type in "regedit" | OK).
3. Browse to HKEY_CURRENT_USER | Software | Quest Software | SQL Navigator X.X (X.X is version of SQL Navigator where issue occurs).
4. Rename the SQL Navigator X.X folder to SQL Navigator X,X_OLD.
5. Re-launch SQL Navigator and re-test the issue.
