When will support for the OBJECT datatype be implementet in direct mode?
We use Devarts drivers just so we dont have to use oracles drivers at all, but this is something i would like to have.
Pseudocode below...
CREATE OR REPLACE TYPE orderrow AS OBJECT
(
id NUMBER(10),
clientid NUMBER(10),
customerid NUMBER(10),
...
...
);
CREATE OR REPLACE TYPE orderrows AS TABLE OF orderrow;
select o.*,
cast(
multiset(
select * from orderrows where clientid = o.clientid and customerid = o.customerid order by order by rownum
) as orderrows)
from order o
Support for OBJECT datatype
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48