Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORACLE V8.0.3 Help
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 Received on Tue Feb 10 1998 - 00:00:00 CST
![]() |
![]() |