RE: Object type

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 23 May 2000 00:52:04 -0400 (EDT)
Message-Id: <10505.106315@fatcity.com>

Your CHAR datatype in the object could be the problem. They are only still around for backwards compatibility with PL/SQL v1. Try changing it to a VARCHAR2(2).
HTH
Lyall Barbour
------Original Message------
From: Sandeep Dubey <sandeep.dubey_at_induscorp.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: May 22, 2000 8:34:39 PM GMT
Subject: Object type

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

Thanks

Sandeep

--
Author: Sandeep Dubey
INET: sandeep.dubey_at_induscorp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

______________________________________________
FREE Personalized Email at Mail.com

Received on Mon May 22 2000 - 23:52:04 CDT