https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192763#M19782 <P>Any answer for this</P> Wed, 17 Feb 2016 14:01:31 GMT srinathd 2016-02-17T14:01:31Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192762#M19781 <P>Hi,</P> <P>We're using Splunk DB Connect 2 on top of our DB (MS SQL server and Oracle DB). In most of our tables, we've BLOB and CLOB fields that contain XML.<BR /> I would like to know how we can fetch and read the actual data from these fields?</P> <P>Thank you in advance,<BR /> Moshe</P> Tue, 25 Aug 2015 13:53:37 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192762#M19781 moshere 2015-08-25T13:53:37Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192763#M19782 <P>Any answer for this</P> Wed, 17 Feb 2016 14:01:31 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192763#M19782 srinathd 2016-02-17T14:01:31Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192764#M19783 <P>You need to use SQL to convert it to a char field</P> <P>E.g</P> <P>Select to_char(clob_field) from table</P> Tue, 29 Sep 2020 16:31:59 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192764#M19783 peterchenadded 2020-09-29T16:31:59Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192765#M19784 <P>The answer to this question is more about SQL than Splunk. Here is what I do in Oracle, but you'll want to ask your DBA (I'm not a DBA by far).</P> <PRE><CODE>SELECT x.object_value.getCLOBVal() FROM XML_TABLE x; </CODE></PRE> <P>Googling around, here's another way to skin that cat.</P> <PRE><CODE>select XMLType( BLOB_COLUMN, 1 /* this is your character set ID. 1 == USASCII */ ) as XML from my_table; </CODE></PRE> Wed, 08 Nov 2017 19:58:15 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192765#M19784 xavierashe 2017-11-08T19:58:15Z https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192766#M19785 <P>So far this is pretty ugly, but only substrings are working for me to extract from a clob. <BR /> My system does not understand the XMLType data type. (DBX 3, Java 8 and Oracle JDBC driver for 18C)<BR /> This runs...<BR /> select DBMS_LOB.substr(a.My_OBJ, 3000 , 1) as MyXML1, DBMS_LOB.substr(a.My_OBJ, 3000 , 3000) as MyXML2 from MyTableWithClob a</P> Tue, 29 Sep 2020 21:18:44 GMT https://community.splunk.com/t5/All-Apps-and-Add-ons/Splunk-DB-Connect-2-How-to-fetch-and-read-XML-data-from-BLOB-and/m-p/192766#M19785 drodman29 2020-09-29T21:18:44Z