loadrunner连接ORACLE的方法,测试通过

 

Action()
{
 int NumRows=0;

int i;

lr_db_connect("StepName=Connect",  

//"ConnectionString=Provider=OraOLEDB.Oracle.1, Data Source=orcl;Server=192.168.9.219; Persist Security Info=True; User ID=sysman;Password=hkbank",
"ConnectionString=Provider=OraOLEDB.Oracle.1; Data Source=yqzldb;Server=192.168.9.21; Persist Security Info=True; User ID=db;Password=db",
"ConnectionName=db1",

"ConnectionType=OLEDB",

LAST );

lr_start_transaction("SQL");

 

NumRows = lr_db_executeSQLStatement("StepName=PerformQuery",

    "ConnectionName=db1",

    "SQLStatement=select * from dba_USERS",

    "DatasetName=MyDataset",

    LAST );

    

lr_end_transaction("SQL", LR_AUTO);//获得查询记录所开销的时间

 

lr_output_message("The query returned %d rows.", NumRows);

 

while(i<NumRows) {

lr_db_getvalue("StepName=GetValue",

        "DatasetName=MyDataset",

        "Column=username",

        "Row=next",

        "OutParam=MyOutputParam",

        LAST);

 

lr_output_message("The value is: %s", lr_eval_string("{MyOutputParam}") );

i=i+1;

    }

 

lr_db_disconnect("StepName=Disconnect",

            "ConnectionName=db1",

            LAST);

 return 0;
}