Re: ORACLE V8.0.3 Help

Manfred Fischer wrote:

> My first object relational ORACLE session does not work!!!
>
> I need help!
>
> What is wrong ?
>
> create type address_type as object
> (street varchar2(50),
> city varchar2(25),
> state char(2),
> zip number)
> /
>
> create type person_type as object
> (name varchar2(25),
> address address_type)
> /
>
> create table customer
> (customer_id number primary key,
> person person_type)
> /
>
> all is executed without error!
>
> but now...
>
> select customer_id, person.name from customer;
>
> ORA-00904 ERROR
You must use dot notation:

select customer_id, c.person.name from customer c;

--

                            Jesper Søndergaard
                            Technical  Analyst
                           Server  Technologies
                              Oracle Danmark

                       Email: jsoender_at_dk.oracle.com


         The statements and opinions expressed here are my own and
         do not necessarily represent those of Oracle Corporation.