loadrunner odbc并发用户时错误
loadrunner ODBC协议的脚本在单个用户下运行不会出现错误, 在并发用户下出现 lr db_exec: " SQL Execute", return-code=-1, native-error-code=1461, SQLState=S1000, SQLError=[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert
loadrunner ODBC协议的脚本在单个用户下运行不会出现错误, 在并发用户下出现
lrdb_exec: "
SQLExecute", return-code=-1, native-error-code=1461, SQLState=S1000, SQLError=[Oracle][ODBC][Ora]ORA-01461: can bind a LONG value only for insert into a LONG column.
论坛结论:
Oracle ODBC Driver Thread Safety:I'm getting ora-01461 and ora-01460 errors when I turn multi-threading on for a pc app that makes oracle odbc connections. When using only a single thread, I never see these errors. I found a posting on the internet that led me to believe that the oracle odbc driver might be the problem.
详见:http://forums.oracle.com/forums/thread.jsp?forum=61&thread=258096&message=&tstart=0&trange=15768373
解决办法:在下载的Oracle ODBC v9.2.0.6.3 包内的说明 ODBCRelnotesUS.htm 找到相关修复的
bug Fixed problem of ODBC failing with an ORA-1461 in a muli-threaded environment. (
Bug2403919, 2383556)
安装Oracle ODBC v9.2.0.6.3 过程:
从 http://metalink.oracle.com 下载patchno:3501955 的 oracle patchsets.要求有高于某个版本的安装工具,则下载p3501955_9205_winnt.rar,再安装或者下载oracle 10g的启动器。
(Oracle ODBC Driver 9.2.0.6.3,ora92063.exe,http://www.oracle.com/technology/software/tech/windows/odbc/h
tdocs/utilsoft.html)
原文转自:http://www.ltesting.net