loadrunner odbc并发用户时错误

发表于:2008-06-16来源:作者:点击数: 标签:loadrunnerLoadRunnerLoadrunner用户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/htdocs/utilsoft.html)
 

原文转自:http://www.ltesting.net