0 Replies Latest reply: May 18, 2013 11:46 AM by 986917 RSS

    Error while mapping two times nested table

    986917
      Hi,

      I have a Product table which has nested ProductSubcategory in it.
      ProductSubcategory nested table also has nested table ProductCategory inside it.
      So there is a nested table inside nested table.

      I designed a dimension on warehoue builder and while mapping, i got "ORA-22913: must specify table name for nested table column or attribute" error.

      I mapped nested tables before with using varray iterator and expand object, but they were nested once. Is there any solution for mapping two or more time nested tables?
      Now i exracted tables and i continuou working but, i wondered is there any way.

      Creation codes are below. Thanx :)

      CREATE TABLE PRODUCT
      (     PRODUCTID NUMBER NOT NULL ,
           ProductSubcategory ProductSubcategory,
           MODIFIEDDATE DATE NOT NULL)
      NESTED TABLE ProductSubcategory STORE AS ProductSubcategory_TABLE
      ( NESTED TABLE ProductCategoryId STORE AS ProductCategory_TABLE);

      CREATE TYPE TYPE_ProductSubcategory AS OBJECT (
           ProductSubcategoryID number ,
           ProductCategoryId ProductCategory ,
           Name Varchar(50) ,
           rowguid varchar2(100) ,
           ModifiedDate date );

      CREATE TYPE TYPE_ProductCategory AS OBJECT (
           ProductCategoryID number ,
           Name Varchar(50) ,
           rowguid varchar2(100) ,
           ModifiedDate date );