Question about objects whose object_type='TYPE'

Question about objects whose object_type='TYPE'

Post by g.. » Wed, 17 May 2000 04:00:00



Hi:

I have a question about oracle object whose type ='TYPE'. I did the
following query to our oracle db:

SQLWKS> select * from all_objects where object_type='TYPE'
     2> and owner='CATPROD2'
     3>
OWNER                          OBJECT_NAME
SUBOBJECT_NAME                 OBJECT_ID  DATA_OBJEC OBJECT_TYPE
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
------------------------------ ------------------------------ ----------
-------------------- ---------- ---------- ------------------ ---------
 --------- ------------------- ------- - - -
CATPROD2
HPXCHARTAB
33332            TYPE               27-APR-00 27-APR-00 2000-01-
28:12:27:51 VALID   N N N
CATPROD2
HPXSTRINGLIST
33333            TYPE               27-APR-00 27-APR-00 2000-02-
28:12:03:28 VALID   N N N
2 rows selected.

Does anyone know how probably these two objects get created? How to
find more info about "TYPE" objects? I thought they might get created
when store procedures (with the same name) were created, but I am not
positive.  We already dropped the store procedures.

Thanks.

Guang

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

Question about objects whose object_type='TYPE'

Post by Michel Cado » Thu, 18 May 2000 04:00:00


These objects are created with CREATE TYPE statement.
You can find informations on them in the views
all_types, all_type_attrs and all_type_methods.

--
Have a nice day
Michel


Quote:> Hi:

> I have a question about oracle object whose type ='TYPE'. I did the
> following query to our oracle db:

> SQLWKS> select * from all_objects where object_type='TYPE'
>      2> and owner='CATPROD2'
>      3>
> OWNER                          OBJECT_NAME
> SUBOBJECT_NAME                 OBJECT_ID  DATA_OBJEC OBJECT_TYPE
> CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
> ------------------------------ ------------------------------ ----------
> -------------------- ---------- ---------- ------------------ ---------
>  --------- ------------------- ------- - - -
> CATPROD2
> HPXCHARTAB
> 33332            TYPE               27-APR-00 27-APR-00 2000-01-
> 28:12:27:51 VALID   N N N
> CATPROD2
> HPXSTRINGLIST
> 33333            TYPE               27-APR-00 27-APR-00 2000-02-
> 28:12:03:28 VALID   N N N
> 2 rows selected.

> Does anyone know how probably these two objects get created? How to
> find more info about "TYPE" objects? I thought they might get created
> when store procedures (with the same name) were created, but I am not
> positive.  We already dropped the store procedures.

> Thanks.

> Guang

> Sent via Deja.com http://www.deja.com/
> Before you buy.


 
 
 

1. Question about objects whose object_type='TYPE'

Hi:

I have a question about oracle object whose type ='TYPE'. I did the
following query to our oracle db:

SQLWKS> select * from all_objects where object_type='TYPE'
     2> and owner='CATPROD2'
     3>
OWNER                          OBJECT_NAME
SUBOBJECT_NAME                 OBJECT_ID  DATA_OBJEC OBJECT_TYPE
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
------------------------------ ------------------------------ ----------
-------------------- ---------- ---------- ------------------ ---------
 --------- ------------------- ------- - - -
CATPROD2
HPXCHARTAB
33332            TYPE               27-APR-00 27-APR-00 2000-01-
28:12:27:51 VALID   N N N
CATPROD2
HPXSTRINGLIST
33333            TYPE               27-APR-00 27-APR-00 2000-02-
28:12:03:28 VALID   N N N
2 rows selected.

Does anyone know how probably these two objects get created? How to
find more info about "TYPE" objects? I thought they might get created
when store procedures (with the same name) were created, but I am not
positive.  We already dropped the store procedures.

Thanks.

Guang

Sent via Deja.com http://www.deja.com/
Before you buy.

2. New user question

3. Simple 'type' question

4. Symix Full-Time Massachusetts

5. type field ''money''

6. Day 10000 Maniacs

7. Question: Combining records to one 'object'

8. UK- Surrey - Database / Unix / Sun Consultant

9. Newbie's question: create user but can't access db object

10. question about 'response' object

11. What's the meaning of object type ?

12. Please help:Can't create sql object types