create type paper_t as object(
author varchar2(4),
title varchar2(9),
first int,
last int
);
/
create type paper_nt as table of paper_t;
/
create type location_t as object(
city varchar2(6),
country varchar(6)
);
/
create type location_nt as table of location_t;
/
create type AC_t as object(
year int,
location location_nt,
papers paper_nt
);
/
create type AC_nt as table of AC_t;
/
create table conference(
name varchar2(4),
AnnualConferences AC_nt)
nested table AnnualConferences store as AC_tb(
nested table location store as location_tb
nested table papers store as paper_tb
);
--inserts values into tables
insert into conference values(
'VLDB', AC_nt(
AC_t(2019,
location_nt(
location_t('Paris', 'France'))),
AC_t(2018,
location_nt(
location_t('Ottawa','Canada'))),
paper_nt(
paper_t('Andy', 'Databases',1,10),
paper_t('Barb','Algebra',11,20),
paper_t('Doug','Calculus',21,30),
paper_t('John','ODMG',1,10),
paper_t('Barb', 'SQL',11,20))));
error occurs when second AC_t table is being made. Help would be greatly appreciated