How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?



How to execute set of multiple SQL queries in Load Runner? Which component in LR would be used to r..

Answer / rajat

Follow below mentioned steps in order to execute query
through LR script-

(1) Establish conn with DB
lrd_open_connection(&Con1, LRD_DBTYPE_ORACLE, "bb",
"lion", "hammer", "", 0, 0, 0);

(2) Enter query
lrd_stmt(Csr1, "select ename from employee where
(sal>=1000)\n", -1, 1, 1, 0);

(3) lrd_bind_col(Csr1, 1, &D21_ENAME, 0);

(4) Execute query
lrd_exec(Csr1, 0, 0, 0, 0);

(5) lrd_fetch(Csr1, -3, 1, 0, PrintRow24, 0);


(6) lrd_close_cursor(&Csr2, 0);

(7) lrd_close_connection(&Con1, 0, 0);

Is This Answer Correct ?    6 Yes 1 No

Post New Answer

More Load Runner Interview Questions

which browsers versions are supported in loadrunner 8.1?if any patches are required for browsers?

3 Answers   Prodigy Technologies, TCS,


When you initialize the vuser what happen?

0 Answers  


How do you report a bug when it is found in perfomance testing using Load Runner

2 Answers   Ness Technologies,


where do you save u r scripts in Load Runner?

2 Answers   TCS,


What is parameterizion?

0 Answers  






on what monitoring tools have u worked on?

1 Answers   Accenture,


The response time of an application was 2.5 seconds.After a minor hotfix,the response time increased to 5 seconds.What analysis can you make out. What are all the things u check in the server side in such a scenario?

4 Answers   Symphony,


How does caching affect performance testing results?

0 Answers  


What is Performance testing?

5 Answers  


There is a scenario like there is one gateway and four application servers.While recording the script for a business function the server address is of gateway. but the gateway route the request to one of these servers.In recording might be request went to server A but it can not be everytime.sometime the request will go to other servers too.How to handle this scenario in preparing the scripts? how to identify tht to which server request went?

1 Answers   Accenture, Fiserv,


Can u Explain me in real time projects any frameworks follows in Loadrunner ? if Yes plz mentiond(Chandana)

4 Answers   SoftSol,


which kind of database counters we use to check the performance of the software and where we can check them?

1 Answers  


Categories