Page 1 of 1

TOraObject with XMLTYPE attribute

Posted: Tue 04 Aug 2015 09:18
by m.ghilardi
I have to develop an application that fetches objects from an Oracle AQ. The Objects are defined as follows

Code: Select all

create or replace type notify_aq_t as object
(
  a_notify_id        number(18),
  a_notify_time    timestamp(0) with time zone,
  a_id                   number(18),
  a_class_name  varchar2(30),
  a_edit_time      timestamp(0) with time zone,
  a_xml               sys.xmltype,
)
/
How do you read the a_xml attribute of this object?

Code: Select all

TOraObject* payload = new TOraObject(new TOraType(AQSession->OCISvcCtx, L"notify_aq_t"));
AQ->Dequeue(payload);
TOraXML* xml = new TOraXML(AQSession->OCISvcCtx, new TOraType(AQSession->OCISvcCtx, L"sys.xmltype"));
xml->Assign(payload->AttrAsObject[L"a_xml"]);//Cannot convert....

Re: TOraObject with XMLTYPE attribute

Posted: Thu 06 Aug 2015 08:40
by AlexP
Hello,

Please send the full sample demonstrating the problem to alexp*devart*com, and specify the exact versions of ODAC, IDE, Oracle client and server.

Re: TOraObject with XMLTYPE attribute

Posted: Mon 10 Aug 2015 10:03
by m.ghilardi
Hello,
I sent the email you requested. If you need further informations please ask.

Re: TOraObject with XMLTYPE attribute

Posted: Tue 11 Aug 2015 08:43
by AlexP
Thank you for the sample, we have reproduced the described problem and will investigate the reason for such behavior.

Re: TOraObject with XMLTYPE attribute

Posted: Fri 04 Sep 2015 12:57
by AlexP
We have added support for xmltype in objects. This feature will be available in the new version, that will be released next week.