TOraObject with XMLTYPE attribute
Posted: Tue 04 Aug 2015 09:18
I have to develop an application that fetches objects from an Oracle AQ. The Objects are defined as follows
How do you read the a_xml attribute of this object?
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,
)
/
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....