How to execute set of multiple SQL queries in Load Runner?
Which component in LR would be used to run the SQL Queries?
Answer Posted / 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 View All Answers
How is automated correlation configured?
What is vugen recording and scripting?
What do you mean by creating vuser script?
What is elapsed time in load runner?
How will you stop the execution of a script on error?
What is think time?
What is loadrunner agent?
Difference b/w 9.1 and 9.5 Versions in LoadRunner?
Why vugen is used in lr?
What are all the types of goals in goal-oriented scenario of load runner?
How do you identify which protocol to use for any application?
What kind of problem we can face regarding hardware, software, network and memory bottleneck during the performance test?
Hi can anyone help with projects using load runner. I learnt loadrunner but don't have a hands on experience on it.. it will be very much helpful if some can help me up with a project. can email me: priya.joslic@gmail.com
What is the modular approach of scripting?
What is stand-alone mode?