Q] How can I insert REF OBJECT?

From: ksjune <ksjune_at_sys.gsnu.ac.kr>
Date: Thu, 10 Jun 1999 16:49:53 +0900
Message-ID: <375F6E21.A9CB8F2E@sys.gsnu.ac.kr>

Hi!!.
I'm beginner in Oracle 8i and manipulating object. I've got errors insert data to object.
Please give me a clue.

SQL> create type addr_t as object ( addr_t_address varchar2(20) );   2 /
Type created.

SQL> create type home_t as object ( home_t_telephon varchar2(15) );   2 /
Type created.

SQL> create type pers_t as object (

  2  name               varchar2(10),
  3  addr                addr_t,
  4  homeref           ref  home_t

  5 );
  6 /

SQL> create table personal of pers_t;
Table created.

SQL> desc personal;

 Name                                        Null?     Type
 -------------------------------- -------- ---------------------------
 NAME                                                   VARCHAR2(10)
 ADDR                                                    ADDR_T
 HOMEREF                                            REF OF HOME_T

SQL> insert into personal values
('ksjune',addr_t('address1'),'0123454'); insert into personal values ('ksjune',addr_t('address1'),'0123454')

*
ERROR at line 1:
ORA-00932: inconsistent datatypes

How can I insert data HOMEREF field?
Please Help!!!!

Thanks in advance....

mailto:ksjune_at_sys.gsnu.ac.kr Received on Thu Jun 10 1999 - 02:49:53 CDT