Can you use the oracle dataadapter to select an XML from a database -

Can you use the oracle dataadapter to select an XML from a database -

using xmlagg query (select xmlagg( xmlelement (... ) select xml database allow more command on format of info pickup.

generating schema based of query gives standard polingstatments single record (which contains xml). creating schema xml easy (following advice on example)

however, adding schema datastructure type of element doesn't work. can select schema in dropdown resets previous selected entry when selected other entry works. (in below image, order_header 1 i'd use.)

i tried ignoring schema's , seeing if map results info in pollingstatement escaped

<pollingstmtrecord><xml>&lt;order_header&gt;&lt;order_id&gt;206817&lt;/order_id&gt;

has ever combined oracle dataadapter xml query? clue went wrong? stored procedure improve solution this? find way info doesn't alter < <

you have few options here:

typed polling

if utilize typedpolling, you'll have extract message (which embedded cdata in xs:string element) in 1 of 2 ways:

in orchestration message assignment shape in binding properties of receive location, here: https://seroter.wordpress.com/2009/07/02/publishing-xml-content-from-sql-server-2008-to-biztalk-server-2009/ (example sql server, focus on biztalk adapter configuration) xmlpolling

if utilize xmlpolling, neat little trick:

create 'dummy' envelope schema (a single record xs:any child, envelope = true, bodyxpath = <any> node) set xmlstoredprocedurerootnodename root node of envelope schema set xmlstoredprocedurerootnodenamespace namespace of envelope schema create schema mathing xml oracle query produces

now xml recieve pipeline "debatch" query schema produce. debatching necessary because query could, in theory, produce multiple documents in single result (which have multiple root nodes, invalid). could, alternatively, design query produce root node , utilize adapter settings assign root node, don't method much myself (i prefer beingness able , test results of query without modification).

xml oracle biztalk