VARRAY within Another VARRAY
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: VARRAY within Another VARRAY

  1. #1
    Join Date
    May 2002
    Posts
    6

    Question

    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.

  2. #2
    Join Date
    Apr 2001
    Posts
    118
    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
  •  



Click Here to Expand Forum to Full Width