Filling property-collection

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
k7e
Posts: 3
Joined: Mon 10 Dec 2012 05:38

Filling property-collection

Post by k7e » Mon 24 Dec 2012 10:03

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
.....
.....

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Filling property-collection

Post by Shalex » Wed 26 Dec 2012 16:40

This question exceeds the goals of our support because it is not provider-specific.
We recommend you to post it at https://forums.oracle.com or http://stackoverflow.com/.

Post Reply