MarkBattle
Member
Hi,
using PLSQL Developer 7.1.5.1398 appears the error message "A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used" when I query a table with a CLOB column in a 21c database.
I try to check "Force OCI7 mode on OCI8" option but then I can't connect. The error: "invalid login or password" appears.
I have the same wrong behaviour with a trial version of PLSQL Developer version 12.0.7.1837 - 64bit.
Until the 19c Database I made querys without problemas and I can modify the values using the rowid, on the query result table records itself.
Do you have a solution for this?
DB: Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
instantclient:
- instantclient-basic-windows.x64-21.13.0.0.0dbru used with PLSQL Developer version 12.0.7.1837 - 64bit
- instantclient-basic-nt-21.12.0.0.0dbru used with PLSQL Developer version 7.1.5.1398 - 32bit
Additional Info from PLSQL Developer version 7.1.5.1398 - 32bit
PL/SQL Developer
Version 7.1.5.1398
01.48194 - 5 user license
Windows Vista (64-bit) 6.2 Build 9200
Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\network\instantclient_21_12x32\oci.dll
Use OCI7: False
DLLs
c:\network\instantclient_21_12x32\oci.dll
TNS File
c:\network\tnsnames.ora
Using
Home:
DLL: C:\network\instantclient_21_12x32\oci.dll
OCI: version 9.2
Oracle Database 21c Standard Edition 2 Release 21.0.0.0.0
Additional Info from PLSQL Developer version 12.0.7.1837 (64 bit)
PL/SQL Developer
Version 12.0.7.1837 (64 bit)
Windows 10 Build 19045
Preferences
Session mode: Multi
OCI Library: C:\network\instantclient_21_13x64\oci.dll
Use OCI7: False
Allow Multiple Connections: True
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)
DLLs
C:\app\product\18.0.0\dbhomeXE\bin\oci.dll
TNS File
c:\network\tnsnames.ora
Using
Home: OraDB18Home1
DLL: C:\network\instantclient_21_13x64\oci.dll
OCI: version 12.1 (21.13.0.0.0)
using PLSQL Developer 7.1.5.1398 appears the error message "A TLOBLocator instance requires OCI8 mode, but OCI7 mode is used" when I query a table with a CLOB column in a 21c database.
I try to check "Force OCI7 mode on OCI8" option but then I can't connect. The error: "invalid login or password" appears.
I have the same wrong behaviour with a trial version of PLSQL Developer version 12.0.7.1837 - 64bit.
Until the 19c Database I made querys without problemas and I can modify the values using the rowid, on the query result table records itself.
Do you have a solution for this?
DB: Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
instantclient:
- instantclient-basic-windows.x64-21.13.0.0.0dbru used with PLSQL Developer version 12.0.7.1837 - 64bit
- instantclient-basic-nt-21.12.0.0.0dbru used with PLSQL Developer version 7.1.5.1398 - 32bit
Additional Info from PLSQL Developer version 7.1.5.1398 - 32bit
PL/SQL Developer
Version 7.1.5.1398
01.48194 - 5 user license
Windows Vista (64-bit) 6.2 Build 9200
Parameters
C:\Program Files (x86)\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\network\instantclient_21_12x32\oci.dll
Use OCI7: False
DLLs
c:\network\instantclient_21_12x32\oci.dll
TNS File
c:\network\tnsnames.ora
Using
Home:
DLL: C:\network\instantclient_21_12x32\oci.dll
OCI: version 9.2
Oracle Database 21c Standard Edition 2 Release 21.0.0.0.0
Additional Info from PLSQL Developer version 12.0.7.1837 (64 bit)
PL/SQL Developer
Version 12.0.7.1837 (64 bit)
Windows 10 Build 19045
Preferences
Session mode: Multi
OCI Library: C:\network\instantclient_21_13x64\oci.dll
Use OCI7: False
Allow Multiple Connections: True
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer 12\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer 12\PlugIns\plsqldoc.dll)
(* is Active)
DLLs
C:\app\product\18.0.0\dbhomeXE\bin\oci.dll
TNS File
c:\network\tnsnames.ora
Using
Home: OraDB18Home1
DLL: C:\network\instantclient_21_13x64\oci.dll
OCI: version 12.1 (21.13.0.0.0)
Last edited:
