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 후 문제 해결 |