Assuming the object is in your schema, this is the query that Toad runs to load it into the Schema Browser (we query against the dba_ or all_ versions of these
I am guessing that either you are looking in the wrong schema, or the object has a typecode other than ‘OBJECT’ or ‘COLLECTION’.
Select user OWNER, o.object_id, o.object_name, o.CREATED, o.last_ddl_time, o.status, t.typecode, t.attributes,
from sys.user_objects o, sys.user_types t
where o.object_type = ‘TYPE’
and t.type_name = o.object_name
and o.subobject_name is null
and t.typecode in (‘OBJECT’, ‘COLLECTION’)
order by owner, typecode, object_name
From: david.osborne [mailto:firstname.lastname@example.org]
Sent: Friday, September 27, 2013 4:54 PM
Subject: [Toad for Oracle - Discussion Forum] Schema Browser Types Tab Not Displaying All
Schema Browser Types Tab Not Displaying All
Thread created by david.osborne
When I click on the types tab I see Object Types and Collection Types. However, those Types created within a package and given a name by Oracle are not displaying. I know they exist and I
can see them when I query dba_objects for my schema. For example,
This shows no Types (i have clicked the + but nothing expands):
When I query dba_objects I see all of my Types:
Is there a Toad option setting for this? I was unable to find one.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.