Re: Oracle8 objects error - ORA-00904: invalid column nam

Should'nt that be 'PERSON_TY.NAME' !!

bijukjoseph_at_hotmail.com wrote:

> 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

--
Rajneesh Kwatra
E-Mail : rk88_at_pantheon.yale.edu
Phone : (203)432-1898

Received on Thu Aug 27 1998 - 12:41:12 CDT