Hi, I have need to read and data that is managed in XML CLOB in orac

Sachin Pandey

A Score Level 1

over 11 years ago

Hi,

I have need to read and data that is managed in XML CLOB in oracle tables. I have query something like:

SELECT NM, USR_FST_NM, USR_LST_NM,DEPT, REGEXP_SUBSTR (ctn.XML,'<approvers>(.*?)</approvers>') AS XML FROM TABLE WHERE ID = "12345".

Data is in XML is like
<approver><userid>abc@nomail.com</userid><status></status><type>Required</type><date></date></approver>

Any suggestions or examples as how can I get the data from query in Appian using Database node?...

Discussion posts and replies are publicly visible

0 Mike Lonsdale over 11 years ago

Hi, use the Stored Procedure Smart Service to pass parameters to the database. The native Oracle functions for parsing XML can then be used to get the data into your preferred format. This can then be returned to Appian by a REF_CURSOR and immediately mapped to a CDT or, just return the XML data in a CLOB and parse this with Appian scripting functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel