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

What is the advantage of running vuser as a process than a thread?

0 Answers  


How do you decide the number of load generator machine required to run a test?

0 Answers  


What is the difference between performance testing and performance engineering?

0 Answers  


While running a scenario in loadrunner controller,the component suddenly hangs and gets closed automatically,the results of the test is no saved and when i open the scenario now,how can i get the results back.?

1 Answers  


What are the main Performance issues in JBoss server? And How to do it?

1 Answers  






If we want to know the size of each component in system how?

0 Answers   AZTEC,


Hi, this is hari. I reciently joined in a small company on testing. there is no team for testing am only the person to do. i know manual testing, i have knowledge on QTP 8.2. I currently working on web based application. but in my company they want Load/Performance testing. plese tell me what i have to do?? i know Load runner but i have no real time exp on that! and In which areas i have to apply QTP??

1 Answers   iSoft,


What is the number of graphs you can monitor using controller at a time? What is the max of them?

0 Answers  


suppose in ur company one new project is came for testing applictaion.. duration 1 year.. so,with in one week manual tester role starts and qtp(any) testers role starts..and others role starts,,,,BUT WHEN THE PERFORMANCE TESTER ROLE STARTS... in the midle of the project or ending of the project..and how many months it takes to starts the load runner tester role begins?

1 Answers  


pls suggest me a good institute for loadrunner in hyderabad also what about a practice project?

15 Answers  


Explain the architecture of ur application ?

1 Answers   Wipro,


What is loadrunner api function?

0 Answers  


Categories