How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
- 1 Answers
- 20731 Views
- I also Faced
- E-Mail Answers
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 |
Hi, How can we know that the app deployed in Weblogic Server in percentage?
What is the need of checkpoints in lr?
Hi guys I am pravash kumar satapathy having 4.5yrs experience in loadrunner .i am providing online training in loadrunner,jmeter .if any body are interested directly u can call me or mail me pravashkumarsatapathy@gmail.com pk.loadrunner-----skype 9437629024
lr_output_message?
What is Response Time?
When loadrunner is used?
What are the Performance Testing Methodologies or life cycle? And Give Brief explanation?
how to perform load testing of a website using any free automation testing tool?
What is a function to capture dynamic values in the web?
What is transaction per second graph(pass)?
How to schedule a scenario?
Which protocols are supported by loadrunner?
WinRunner 
