access xml data CLOB from database using QTP
Hi All ,
I need help in accessing values from xml files which is in database tables.I am able to get the values of the other cells except the cell which has the xml file embedded and datatype of which is CLOB.
I need to check the value from xml files.
Currently i am using just ADODB.Connection and ADODB.Recordset object and looping through the recordset to get values.
Kindly help , i am in need of solution.lease post code in case you have.
Accessing CLOB data from oracle using QTP
Even I need answer for the above issue. Any help would be appreciated
That's useful SQL to know but when I first tried this, the problem I had was that the ADODB connection wouldn't pull data from an XML field. I tried converting it to a CLOB but it was too big to pull down in one go. What I ended up doing, which was painfully slow and ugly, was to pull the data down in chunks and reassemble it. I can give you the code for that if you need it. It's something of a last resort, though.
After 6 months of suffering through that, I got one of the developers to write me an API that would do the query and return the XML through HTTP.