1 Reply Latest reply: Jan 2, 2013 7:42 PM by 615576 RSS

    Filling property-collection

    982034
      We have got an object. The object has some properties. One of properties is collection. How we can populate both properties and property-collection in 1 query.

      CREATE OR REPLACE TYPE pack.D_O IS OBJECT(
      r number,
      l number,
      s_pack number(3),
      s_pack_name varchar2(50),
      n_uch number(5),
      type_name varchar2(30),
      date_att date,
      cause_att number(2),
      cause_att_name varchar2(250)
      )

      ----------------------------------------------------------------------
      CREATE OR REPLACE TYPE pack.D_T IS TABLE OF pack.D_O;

      ----------------------------------------------------------------------
      CREATE OR REPLACE TYPE pack.d2_o IS OBJECT(
      d NUMBER(5),
      n VARCHAR2(75),
      m VARCHAR2(75),
      f number,
      z pack.D_T
      )

      ----------------------------------------------------------------------
      select pack.d2_O(manager,
      name,
      office,
      regalias,
      ? -- how to fill "z" collection here, using subquery or something similar?
      )
      from
      t1,t2
      where
      .....
      .....