- Oracle client has to be installed on QTP (or UFT) host.
- Assuming the tnsnames.ora file contains the desired database information.
Using following two functions can help you to execute SQL queries.
How you make use of these functions is as following:
v_sysdateFromDB = executeQuery(Parameter("p_db"), "select sysdate from dual")