0 Replies Latest reply: Feb 27, 2013 4:04 AM by 993648 RSS

    nested XML structure from Oracle

    993648
      Using the SQL Adapter i BizTalk, calling a SQL Stored procedure on a MS SQL DB, I can get a nice nested XML structure using p JOIN ii and FOR XML AUTO, like this

      <p code="DK003">
      <ii stamp="2013-01-14T10:27:38.790"value="180.702052"price="184.000000">
      <d Dividend="2.50"DividendDate="2012-03-29T00:00:00" />
      </ii>
      <ii stamp="2013-01-14T10:27:38.790"value="181.702052"price="14.000000">
      <d Dividend="2.50"DividendDate="2012-03-29T00:00:00" />
      </ii>
      </p>

      How can I get the same on Oracle ??