Re: Oracle 8 - object types

Your query seems too poor.
It seems like the second b field is the b field from type person_t, as the b obj_t column references it.
I deduct that the second b refers to the obj_t, which is seen as type person_t.
So it could be normal that the obj table is related to field of type person_t.
HTH
Michel
:-)

Marco Savard wrote:

> Hello,
>
> I'm using Oracle 8. I have a problem with object types in Oracle
> 8. I entered the
> following statements in SQL-Plus on my Oracle database:
>
> create type obj_t as object (
> a char,
> b ref person_t);
>
> create table obj (
> a number,
> b obj_t,
> c person_t);
>
> When I consult how this information is stored in the database by
> entering the following query:
>
> select table_name, column_name, data_type
> from user_tab_columns
> where table_name = 'OBJ';
>
> I got the following results:
>
> TABLE_NAME: COLUMN_NAME: DATA_TYPE:
> obj a number
> obj b obj_t --ok
> obj b person_t --b was not declared as
> person_t, but rather as obj_t
> obj c person_t
>
> I want to get my three original columns (a, b and c) and their
> corresponding data types (number,
> obj_t and person_t). How I can know that b was declared as obj_t and
> not as person_t ?
>
> Thank you for your help.
>
> Marco Savard
> marco.savard_at_silverrun.com
Received on Wed Apr 01 1998 - 00:00:00 CST