Results 1 to 3 of 3

Thread: Nested Table Error

  1. #1
    Contributing Member
    Join Date
    Mar 2008
    Answers
    66

    Nested Table Error

    While creating a nested table it is showing message

    ORA-22913: must specify table name for nested table column or attribute

    Do we need to specify nested table name seperately? If yes, then how to specify the table name. It has used the following steps while creating a nested table.

    create or replace type animal_ty as object
    ( breed varchar2(25),
    name varchar2(25),
    birthdate date);

    create type animals_nt as table of animal_ty;

    create table breeds
    (
    breedname varchar2(25),
    animals animals_nt);


  2. #2
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    Re: Nested Table Error

    At the end of table definition add nestedtablename

    Ex:-
    create table breeds
    (
    breedname varchar2(25),
    animals animals_nt)
    NESTED TABLE ANIMALS STORE AS ANIMALS_NT_TAB;


  3. #3
    Junior Member
    Join Date
    Aug 2011
    Answers
    1

    Re: Nested Table Error

    i have this problem:

    1.-
    CREATE OR REPLACE TYPE OBJECT1 AS OBJECT(
    item_id Number ( 6 ),
    descr varchar2(30 ),
    quant Number ( 4,2)
    );
    /
    2.-
    CREATE OR REPLACE TYPE OBJECTS1 AS TABLE OF OBJECT1;
    /

    3.-
    CREATE OR REPLACE TYPE OBJECT2 AS OBJECT(
    ATTR VARCHAR2(1 BYTE),
    ATTR2 OBJECTS1
    );
    /

    4.-
    CREATE TABLE TABLE_TEST_OBJECT(
    OP VARCHAR2(8 BYTE),
    ATTR OBJECT2
    );
    /

    i get ORA-22913: must specify table name for nested table column or attribute

    when i try to create TABLE_TEST_OBJECT

    do you know, how can i resolve this problem?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact