使用TOAD(8.5.3)開啟ORACLE10.2中儲存過程報錯:'IN' is not a valid integer value
這種錯誤只針對那種有輸入,輸出引數設定的儲存過程。如果無引數就沒問題。
這是軟體固有的bug ,最新版了9。0
Toad 8.6.1已經修復了這個問題
,如下為官方自述 :
TOAD version 8.6.1 is provided as a patch with selected fixes to version 8.6. This patch version is not intended to address all reported issues. Rather, it addresses a subset of the issues, selected based on severity and complexity.
In particular, the following problems are addressed:
When Oracle patched version 10.2.0.1 with version 10.2.0.2 the structure of the ALL_ARGUMENTS view changed, causing Toad 8.6.0 or earlier to state: "IN " is not a valid integer value when selecting procedures in the Schema Browser or loading them into the Procedure Editor. Toad 8.6.1 remedies this problem.
這是軟體固有的bug ,最新版了9。0
Toad 8.6.1已經修復了這個問題
,如下為官方自述 :
TOAD version 8.6.1 is provided as a patch with selected fixes to version 8.6. This patch version is not intended to address all reported issues. Rather, it addresses a subset of the issues, selected based on severity and complexity.
In particular, the following problems are addressed:
When Oracle patched version 10.2.0.1 with version 10.2.0.2 the structure of the ALL_ARGUMENTS view changed, causing Toad 8.6.0 or earlier to state: "IN " is not a valid integer value when selecting procedures in the Schema Browser or loading them into the Procedure Editor. Toad 8.6.1 remedies this problem.
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-85142/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- jdbc使用call呼叫儲存過程報錯JDBC儲存過程
- MySQL 建立儲存過程報錯MySql儲存過程
- 查詢儲存過程報錯資訊儲存過程
- 使用儲存過程儲存過程
- pl/sql developer除錯儲存過程報錯處理SQLDeveloper除錯儲存過程
- ADO中sqlserver儲存過程使用SQLServer儲存過程
- MySQL儲存過程中如何使用ROLLBACKMySql儲存過程
- 儲存過程中DDL錯誤一例儲存過程
- 在儲存過程A中呼叫儲存過程B的結果儲存過程
- SQL Server儲存過程中raiserror的使用SQLServer儲存過程AIError
- ADO中sqlserver儲存過程使用 (轉)SQLServer儲存過程
- plsqlDevloper 儲存過程的除錯SQLdev儲存過程除錯
- 應用儲存過程執行報錯解決方案儲存過程
- oracle 儲存過程執行報錯ORA-12828Oracle儲存過程
- ORACLE匯出文字到MYSQL 報錯 Incorrect integer value: ''OracleMySql
- Sqlserver中的儲存過程SQLServer儲存過程
- PB中呼叫儲存過程儲存過程
- 儲存過程中拼接字串儲存過程字串
- java中呼叫儲存過程Java儲存過程
- 在toad_plsql developer_oracle sql developer呼叫儲存過程SQLDeveloperOracle儲存過程
- Mysql 儲存過程的使用MySql儲存過程
- 儲存過程中使用cursor儲存過程
- 儲存過程中巢狀儲存過程的變數執行方式儲存過程巢狀變數
- Hibernate中怎麼使用儲存過程呢?儲存過程
- 使用儲存過程(PL/SQL)向資料庫中儲存BLOB物件儲存過程SQL資料庫物件
- (轉)如何oracle除錯儲存過程Oracle除錯儲存過程
- openGauss 支援儲存過程除錯儲存過程除錯
- MySQL儲存過程詳解 mysql 儲存過程MySql儲存過程
- 儲存過程儲存過程
- 如何令暫時不想使用的procedure儲存過程由valid變成invalid儲存過程
- jsp中呼叫儲存過程JS儲存過程
- 儲存過程中慎用 execute immediate儲存過程
- java中呼叫ORACLE儲存過程JavaOracle儲存過程
- Laravel 中使用 MySQL 儲存過程LaravelMySql儲存過程
- mysql 遊標的使用(儲存過程)MySql儲存過程
- oracle 儲存過程遊標的使用Oracle儲存過程
- [20190118]toad下如何除錯儲存過程和函式.txt除錯儲存過程函式
- Oracle中定義package以及儲存過程的使用OraclePackage儲存過程