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的啟動器。
?。∣racle ODBC Driver 9.2.0.6.3,ora92063.exe,http://www.oracle.com/technology/software/tech/windows/odbc/h
tdocs/utilsoft.html)
原文轉自:http://www.anti-gravitydesign.com