Oracle8 objects error - ORA-00904: invalid column nam

Dear all,

I have created a customer table as shown below.

SQL> desc customer

 Name                            Null?    Type


 ------------------------------- -------- ----


 CUSTOMER_ID                              NUMBER
 PERSON                                   PERSON_TY

SQL> desc person_ty
 Name                            Null?    Type


 ------------------------------- -------- ----


 NAME                                     VARCHAR2(25)
 ADDRESS                                  ADDRESS_TY

SQL> desc address_ty
 Name                            Null?    Type


 ------------------------------- -------- ----


 STREET                                   VARCHAR2(50)
 CITY                                     VARCHAR2(25)
 STATE                                    CHAR(2)
 ZIP                                      NUMBER

SQL> select * from customer
  2 /

CUSTOMER_ID ----------- PERSON(NAME, ADDRESS(STREET, CITY, STATE, ZIP))

• 1 PERSON_TY('Biju K. Joseph', ADDRESS_TY('Street A', 'City Blue', 'CA', 23423))

          2
PERSON_TY('Shafi Ulla', ADDRESS_TY('Street B', 'City Red', 'AR', 234234))

SQL> But when I do a select as shown below it gives an error

SQL> select person.name from customer
  2 /
select person.name from customer

              *
ERROR at line 1:
ORA-00904: invalid column name

This should work as per oracle manual !

Where am I going wrong ?

Thanks in Advance

Biju Joseph

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 27 1998 - 03:31:20 CDT