-
Contributing Member
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);
-
Expert Member
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;
-
Junior Member
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
-
Forum Rules