Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Object Type - ORA-00904
I am walking thru chapter 4 in "Oracle 8 The Complete Reference". I
created an ADDRESS_TY object and a PERSON_TY object then a
CUSTOMER table as shown. I inserted a record using the appropriate
constructor methods. When I perform a DESCRIBE CUSTOMER I get
... PERSON PERSON_TY instead of NAMED TYPE as shown in the book. I
perform SELECT CUSTOMER_ID,PERSON.NAME FROM CUSTOMER and receive the 904
error, invalid column name.
Has anyone else run into this? What am I doing wrong or missing?
--
Brook A. Swenson
Oracle DBA
Lands' End
608-935-6516
Received on Tue Jun 23 1998 - 17:54:31 CDT