Powerbuilder and Oracle
I have downloaded and installed the evaluation version of LoadRunner.
I want to use it for performancetesting a Powerbuilder (version 10) application that runs with
Oracle9i Client 18.104.22.168.0
When recording a script I encounter the following problem:
Although there are 2 variables to bind in the sql-statement, LoadRunner only binds one variable.
And that binding is incorrect as well, LoadRunner does not record the right value of the variable.
(that happens in all SQL-statements with variables to bind).
<font class="small">Code:</font><hr /><pre>
lrd_ora8_stmt(OraStm1, "SELECT bdnr, lnam\r\nFROM ppvbed \r\n
WHERE ( ppvbed.bdnr "
"= :an_bdnr ) \r\nor ( (:as_lnam = lnam) \r\nand ("
":as_lnam <> ' ') )\r\n/*ORA*/", 1, 0, 0);
lrd_assign(&D2, "0", 0, 0, 0);
lrd_ora8_bind_placeholder(OraStm1, &OraBnd2, "", &D2, 0, 0, 0);
lrd_ora8_exec(OraSvc1, OraStm1, 0, 0, &uliRowsProcessed, 0, 0, 0, 0, 0);
Is there a solution for that problem?
Thanks very much.
Re: Powerbuilder and Oracle
Thank you for your question. Support for all issues related to the evaluation of LoadRunner prior to purchase is the exclusive domain of HP|Mercury or your HP|Mercury VAR. There are a number of reasons for this
<ul type="square">[*]These organizations have a compelling financial interest in finding a solution to your problems, for if these issues cannot be solved, you will not be purchasing LoadRunner and will likely be purchasing a competing solution, such as offerings from Borland or Compuware. Be sure and leverage this situation, make your VAR or your vendor earn your business. Use this as an opportunity to evaluate the product as well as the company.[*]Users who are evaluating LoadRunner almost exclusively have no training in LoadRunner. This forum is not for users who have not benefited from training, it is for professionals who are engaged ina production use of the tool. Users who are new to LoadRunner and new to performance testing are almost universally engaging in bad process or have a fundamental misunderstanding of the tool or how to properly begin testing. Your pre sales systems engineer for your VAR or Vendor should be keeping your behavior in check by monitoring your activity in relation to your pre-purchase evaluation criteria.[*]Historically, all sorts of pirates have used evaluation licenses for production use without purchasing LoadRunner, in direct violation of the license agreement of the tool and also impacting the professional appearance of all service providers for LoadRunner. You may not be in this category, but unfortunately all who show up here for assistance with "evaluation," "trial," or "trail" licenses get tarred by the brush of these previous bad actors. Rather than take the risk of accidentally supporting a pirate, we turn all evaluation license questions back to the VAR/Vendor, where if the question is legitimate and the evaluation activity legitimate, then there is a skilled support mechanism available. As an industry we only have ourselves to blame for this problem, for we tolerated questions from pirates for far too long in this forum. That is no longer the case.[/list]
Good luck in your evaluation! Make your partner in your evaluation efforts, your VAR or vendor, work for your hard earned money used to purchase the tool. Budget for both training and mentoring after your purchase as well as time to come up to speed before your first performance testing engagement. Once you are up to speed, make it a part of your job function to give back to the community.
Replace ineffective offshore contracts, LoadRunnerByTheHour
. Starting @ $19.95/hr USD.
Put us to the test, skilled expertise is less expensive than you might imagine.
Twitter: @LoadRunnerBTH @PerfBytes