Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Explain performance testing life cycle.

0 Answers  


Plz someone tell me about user interface testing and backend testing and hw did u use it in ur project.plz give a detail answer i need to explain it to the interviewer. plzzzzzzzzz guys its urgent.

3 Answers  


Hi Am new for load testing.I got the following error..Please check it and do needful.. Action.c(213): To location "http://10.239.32.23/CCM-NIELSEN- PUNE/wfErrorApplication.aspx" [MsgId: MMSG-26693] Action.c(213): Found resource "http://10.239.32.23/CCM- NIELSEN-PUNE/ccms_css.css" in HTML "http://10.239.32.23/CCM- NIELSEN-PUNE/wfErrorApplication.aspx" [MsgId: MMSG-26659] Action.c(213): Found resource "http://10.239.32.23/CCM- NIELSEN-PUNE/images/ERROR.GIF" in HTML "http://10.239.32.23/CCM-NIELSEN- PUNE/wfErrorApplication.aspx" [MsgId: MMSG-26659]

1 Answers  


Hi all, I am having an interview on LoadRunner (SAP Web Protocol). I am wondering if somebody can help me with some interview questions at a 2 yr Scriptor level. Thanks and all answers are much appreciated.

0 Answers  


where we can insert the ANALYSIS RESULTS AND RESPONSE TIMES? any document is using to store this? and sending this document to whoom?

3 Answers  


What are the major differences between Web Server and Application Server?

3 Answers  


Explain the recording mode for web Vuser script?

6 Answers   Wipro,


How do you estimating target load levels in loadrunner?

0 Answers   Allianz,


)Example of web_submit_form is the regestration form which u have to fill while creating a mail_Id Example of web_submit_data is the login page contains the fields like user name & PWD. Is this correct answer for diff btn web_submit_form&web_submit_data and their examples.

3 Answers   EDS,


on what monitoring tools have u worked on?

1 Answers   Accenture,


what is the differance between standard log and extended log?

5 Answers  


U r taken ORD=All in correlated function.What it represents.Now i want to capture the ORD=3 occurance& place it in web_submit_data of vu gen script. How can u do it?

5 Answers   EDS,


Categories