Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Storing Nested tables type as database table columns

user10549528Mar 8 2019 — edited Mar 8 2019

Hello gurus,

I am creating this similar structure in my application to hold nested table type in a database table column but i am getting this error , please assist me

create type degree_subjects as object

(

subject1 varchar2(20),

subject2 varchar(20)

);

--create subject table

CREATE TYPE subjects_tt AS TABLE OF degree_subjects;

-- A degree has multiple subjects like maths etc.

create type emp_degre as object

(

degree_type varchar2(20),

degree_name varchar(20),

subjects subjects_tt

);

CREATE TYPE emp_degree_tt AS TABLE OF emp_degre;

-- employee holds degrees

CREATE TYPE emp_rt AS OBJECT

             ( empno NUMBER(4)

             , ename VARCHAR2(10)

             , mgr   NUMBER(4)

             , emp_deg emp_degree_tt

             );

CREATE TYPE emp_tt AS TABLE OF emp_rt;

create table test_dest

(

   key number,

   employees emp_tt

)nested table employees store as employees_tab ;

Here in the last statement i am getting this error.Basically the cloumn employees is a nested table type which is 2 level in depth , it is holding emp_deg_tt table which has subjects_tt nested table.

is it possible to create this table , please assist.

ORA-02320: failure in creating storage table for nested table column EMPLOYEES

This post has been answered by Mustafa KALAYCI on Mar 8 2019
Jump to Answer
Comments
Post Details
Added on Mar 8 2019
3 comments
2,283 views