create object view error

From: <tedchyn_at_yahoo.com>
Date: Thu, 11 Mar 1999 02:13:51 GMT
Message-ID: <7c78sn$te2$1_at_nnrp1.dejanews.com>

Sir:

Following error message appeared when I tried to create an object view. Any insight is greately appreciated (oracle 8.0.5).

Thanks in advance. Please reply to : tedchyn_at_yahoo.com

SQL> desc address_ty

 Name                            Null?    Type
 ------------------------------- -------- ----
 STREET                                   VARCHAR2(50)
 CITY                                     VARCHAR2(25)
 STATE                                    CHAR(2)
 ZIP                                      NUMBER

SQL> create table test(address address_ty);

Table created.

SQL> desc test

 Name                            Null?    Type
 ------------------------------- --------          ----
 ADDRESS                                  ADDRESS_TY

SQL> create or replace view test_ov(address)   2 as select address_ty(street,city,state,zip) from test; as select address_ty(street,city,state,zip) from test

                                                          *

ERROR at line 2:
ORA-00904: invalid column name point to ZIP field

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 03:13:51 CET