QTP script for reading CLOB object in Oracle DB
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.
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