-
Hi All,
In Oracle 8i, is it possible to create a Varray within another Varray. Be more specific, we created one object type. and we created Varray of that object type. We created another object type that contains Varray in one field. When i try to create again Varray of this latest object that contains Varray, it says, Varray can't contain Varray, Nested table and Blob. Please answer.
create type EQP_EVENT as OBJECT(EVENTID Number, EVENTDESC varchar2(60));
create or replace type EQP_EVENT_VA as varray(6) of EQP_EVENT;
create type EQUIP as OBJECT ( EQP_ID NUMBER , EQP_NAME VARCHAR2(60), EVENT_VA EQP_EVENT_VA);
CREATE OR REPLACE TYPE EQUIP_VA AS VARRAY(3) OF EQUIP;
Please answer this question.
Regards,
Sultan.
Regards,
Sultan.
-
As the error message told you, you can't do that in 8i.
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
|
Click Here to Expand Forum to Full Width
|