Toad World® Forums

Schema Browser Types Tab Not Displaying All

Hi,

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.

Warm regards,

David

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
views otherwise).

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,
t.methods

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:bounce-davidosborne@toadworld.com]

Sent: Friday, September 27, 2013 4:54 PM

To: toadoracle@toadworld.com

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

Hi,

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.

Warm regards,

David

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Hi John,

I am in the right schema. The issue arises with your join to user_types because these don’t exist in that view. They are only in user_objects.

Create a Type inside a PL/SQL package and Oracle will give it a name like ‘SYS_PLSQL_74267_9_1’ (the number will be different). Then query user_objects and you’ll see it with an object_type of ‘TYPE’. However it will not exist in user_types! (i can’t find it in user_types, all_types, or dba_types).

Or, is this tab not intended to display PL/SQL types? Where else should I look?

Thank you,

David

Oracle: 11.2.0.1

Toad 12.1.0.22

No, we don’t show those. To be honest, I have never heard of them before our conversation. Can you send me a small code sample of how you create them?

From: david.osborne [mailto:bounce-davidosborne@toadworld.com]

Sent: Friday, September 27, 2013 5:23 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Schema Browser Types Tab Not Displaying All

RE: Schema Browser Types Tab Not Displaying All

Reply by david.osborne

Hi John,

I am in the right schema. The issue arises with your join to user_types because these don’t exist in that view. They are only in user_objects.

Create a Type inside a PL/SQL package and Oracle will give it a name like ‘SYS_PLSQL_74267_9_1’ (the number will be different). Then query user_objects and you’ll see it with an object_type
of ‘TYPE’. However it will not exist in user_types! (i can’t find it in user_types, all_types, or dba_types).

Or, is this tab not intended to display PL/SQL types? Where else should I look?

Thank you,

David

Oracle: 11.2.0.1

Toad 12.1.0.22

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.