Currently i have movie_tab table of User-defined-Type of Movie_objtyp
and i also created Multi_v_tab table which have a REFVARRAY column as Varray of reference Movie_objtyp User-defined-Type.

trying to SCOPE that REFVARRAY column in Multi_v_tab table... it seem like not working with this
ALTER TABLE MULTI_V_TAB ADD
(
SCOPE FOR (REFARRAY) IS MOVIE_TAB
);

is it possible to scope this kind of Varray column?


--DDL---simplfied

......
create table MOVIE_TAB OF MOVIE_OBJTYP;
......

create type multi_varray as varray(10) OF REF MOVIE_OBJTYP;
/
CREATE TYPE MULTI_V_OBJTYP AS OBJECT
(
NAME VARCHAR(10),
TESTDATE DATE,
REFARRAY MULTI_VARRAY
);
/
create table Multi_v_tab OF MULTI_V_OBJTYP;