OLE Object

[sesling]

I am using MS Access 2003 to link to an 11g Oracle Database. There is an Oracle Table that has an OLE Object column field and I want to be able to get the information from that column. I can run the following SQL statement from an SQL Plus session and get the values but I want to run the same type of statement in MS Access. I have researched the web but cannot find an answer. How can I convert the statement below so it will run in MS Access?

select id, data_id, data_type, state,
extract(payload,'/payload/pfId/text()').getStringVal() PfId,


extract(payload,'/payload/entityId/text()').getStringVal() Entity,
extract(payload,'/payload/region/text()').getStringVal() Region,
extract(payload,'/payload/recCnt/text()').getStringVal() RecCnt
from data_track
where existsNode(payload,'/payload/pfId') = 1

[June7]

I read that Extract is an Oracle function to get value from a date or interval value.

Looks like to me you are importing data. Can you link to the table or otherwise connect to the Oracle database? Maybe this will help http://www.orafaq.com/node/60

ExistsNode:
"EXISTSNODE determines whether traversal of an XML document using a specified path results in any nodes. It takes as arguments the XMLType instance containing an XML document and a VARCHAR2 XPath string designating a path. The optional namespace_string must resolve to a VARCHAR2 value that specifies a default mapping or namespace mapping for prefixes, which Oracle Database uses when evaluating the XPath expression(s)."
I have no idea how this would translate in Access SQL.