Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORACLE V8.0.3 Help

ORACLE V8.0.3 Help

From: Manfred Fischer <manfred.fischer_at_rm.sni.de>
Date: 1998/02/10
Message-ID: <6bqa4e$d2t$1@linus.sni.de>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US