Highlighted
elearning Absent Member.
Absent Member.
962 views

QTP script for reading CLOB object in Oracle DB

Hi,

 

I need to read a CLOB object in Oracle 11g database from UFT(or QTP). Can someone tell me the way to read the CLOB object value from the result set?

 

I have Oracle 11g ODBC driver installed in my machine.

 

I have tried getCLOB() method and the query is not getting executed.

0 Likes
2 Replies
elearning Absent Member.
Absent Member.

Re: QTP script for reading CLOB object in Oracle DB

Has anyone worked with reading CLOB object from QTP/UFT?

Raviteja2 Absent Member.
Absent Member.

Re: QTP script for reading CLOB object in Oracle DB

Update the quey as below :

select EXTRACTVALUE(xmltype(FIELD NAME), '/<PARENT TAG NAME>/<CHILD TAG NAME>/<CHILD1 TAG NAME>) from Table_Name

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.