TOraObject with XMLTYPE attribute

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

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

[m.ghilardi]

Hello,
I sent the email you requested. If you need further informations please ask.

[AlexP]

Thank you for the sample, we have reproduced the described problem and will investigate the reason for such behavior.

[AlexP]

We have added support for xmltype in objects. This feature will be available in the new version, that will be released next week.