DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Parsing multiple versions using XML table

e6de7f2c-e1dc-4e3c-838d-f07eabaccfa2May 11 2015 — edited May 12 2015

Hi,

Is there a way we can parse multiple versions using XML table at one go, for example i have the following query some paths are available in Version 2 and some are in version 3.

can i use the query to handle both the versions at one go.so if the data is related to version 2 it would give me the data if its a valid path from version 2 and null for if its a path availble in version3 only and vice versa.

SELECT

xt.*

FROM PMTS_HUB_OWNER.MINF x,

XMLTABLE (

XMLNamespaces ('http://fundtech.com/SCL/CommonTypes' AS "fndt",DEFAULT 'urn:iso:std:iso:20022:tech:xsd:pacs.003.001.02 and I want to accomodate version 3 as well here pacs.003.001.03'),

'/fndt:FndtMsg/fndt:Msg/fndt:Pmnt/Document/FIToFICstmrDrctDbt'

PASSING x.XML_ORIG_MSG

COLUMNS

ORGNLINSTRID VARCHAR2(35) PATH 'DrctDbtTxInf/PmtId/InstrId',

ORGNLENDTOENDID VARCHAR2(35) PATH 'DrctDbtTxInf/PmtId/EndToEndId',

Cdtr_AdrLine_1 varchar2(70) Path 'DrctDbtTxInf/Cdtr/PstlAdr/AdrLine[1]' ,

Cdtr_AdrLine_2 varchar2(70) Path 'DrctDbtTxInf/Cdtr/PstlAdr/AdrLine[2]' ,

CdtrAgt_AdrLine_1 varchar2(70) Path 'DrctDbtTxInf/CdtrAgt/FinInstnId/PstlAdr/AdrLine[1]' ,

CdtrAgt_AdrLine_2 varchar2(70) Path 'DrctDbtTxInf/CdtrAgt/FinInstnId/PstlAdr/AdrLine[2]'

)xt

WHERE P_ORIG_MSG_TYPE='Pacs_003'

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 9 2015

Added on May 11 2015

#xml, #xquery

1 comment

1,225 views

DevOps, CI/CD and Automation

Parsing multiple versions using XML table

Comments

Post Details