Title |
[ORACLE] lobカラム暗号化時にORA-22292エラー。 | Product |
Plug-In |
---|---|---|---|
Phenomenon |
Oracle 9.2.0.4以下のバージョンでlobカラムを暗号化する際にORA-22292 cannot open a LOB in read-write mode without a transactionエラー発生。 |
||
Cause |
オラクルバグと類似している。
Bug 1736740 ORA-22292 opening TEMP LOB from JAVA using KRPB driver This note gives a brief overview of bug 1736740. affected version : 9.0.1.4, 9.2.0.4 Description "ORA-22292: Cannot open a LOB in read-write mode without a transaction" can occur when trying to open a temporary lob in the KRPB driver (from a Java Procedure stored in the database). Workaround Avoid opening temporary lobs from stored Java |
||
Solution |
オラクルバージョンを9.2.0.1から9.2.0.6へとupgradeした後、問題解決。 |