Inserting into nested object lists

From: <eric_levin_at_my-deja.com>
Date: Wed, 22 Nov 2000 21:56:50 GMT
Message-ID: <8vhff1$acu$1@nnrp1.deja.com>

create type obect_type as (

colum_one       varchar(80)
column_two      varchar(80)

column_three varchar(80)
)

create type object_type_list as table of object_type

then we used the object_type_list as a colum in a table We would like to insert values into this object for certain records in the table. The following did not work? Does anyone have any suggestions?

insert into THE (
  SELECT c.table_column_name
   FROM table c
   WHERE c.primary_key = 3
  )
values( object_type('abc','ABC','intermediate'))

Error message: ORA-22908: reference to NULL table value

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 22 2000 - 15:56:50 CST