Schema Browser Types Tab Not Displaying All

Toad for Oracle
1

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

2

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.

3

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

4

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.