Object type

From: Sandeep Dubey <sandeep.dubey_at_induscorp.com>
Date: Mon, 22 May 2000 15:32:09 -0400
Message-Id: <10505.106271@fatcity.com>

Hi All,

I created an object type and did as in following steps.

CREATE TYPE Address_tp AS OBJECT (

  Street         VARCHAR2(200),
  City           VARCHAR2(200),
  State          CHAR(2),
  Zip            VARCHAR2(20)

  )
/

CREATE TABLE CUSTOMER
(NO NUMBER,
C_ADD Address_tp)
/

insert into customer values(1,address_tp('12','Falls church','VA','22043'))
/

select no,c_add.street from customer
/

Last select statement gives invalid column error. What is wrong? I am using 8.1.5 and Sqlplus 8.0.5.

Help me Received on Mon May 22 2000 - 14:32:09 CDT