Support for OBJECT datatype

Support for OBJECT datatype

Postby JGr » Thu 23 Sep 2010 12:11

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
JGr
 
Posts: 1
Joined: Thu 23 Sep 2010 12:03

Postby StanislavK » Fri 24 Sep 2010 13:49

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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle