Big news! The community will be moving to a new platform April 21. Read more.
Big news! The community will be moving to a new platform April 21. Read more.
Absent Member.. Absent Member..
Absent Member..
3034 views

Does Loadrunner Vuser support calling a SQL file?

Is there anyway to call a SQL file(specifically SQL Server) in Loadrunner and have Loadrunner execute it?   I know you can run SQL statements using lr_db_executeSQLStatement(Web Service protocol) or by lrd_stmt(ODBC protocol)  but these accept one SQL statement.   I need to run a large SQL script that would be too complex to break down into several of the above functions.

 

If running a file is not an option,  what about calling stored procedures?  Can they be called in Loadrunner?

 

Thanks,

Raymond

Tags (1)
0 Likes
4 Replies
Absent Member.. Absent Member..
Absent Member..

This is not possible, however  you can create a stored procedure on SQL and callit from LoadRunner.

hope this helps.

 

cheers

0 Likes
Absent Member.. Absent Member..
Absent Member..

Thanks Editus!   I also have started using the .NET protocol using C# in Loadrunner and being able to call multiple SQL statements and parameterize much better than in ODBC protocol.

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Hi,

 

I would really appreciate if you can post some .NET examples to execute long queries from a SQL File.

 

Thanks in advance,

 

Vaibhav

0 Likes
Absent Member.. Absent Member..
Absent Member..

Writing SQL statements in vugen is explained in a simple way

 

http://loadrunner95.blogspot.com/2016/10/oracle-database-load-testing.html

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.