Support for OBJECT datatype

[JGr]

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

[StanislavK]

Working with Oracle objects highly relies on the OCI functionality, hence an Oracle client is needed. At the moment, we do not plan to implement the Oracle objects support in the Direct mode.