"OCI-21500: internal error code..." with query column type CLOB

[Jean Silva]

Hi All,

Please, when I execute query SQL with column from type CLOB show me error bellow.

"OCI-21500: internal error code, arguments: [19100], [2], [], [], [], [], [], []"

My OS Windows 7 Enterprise 64-bits, more info bellow.

-- Start info --

PL/SQL Developer
Version 8.0.4.1514
02.90260 - 5 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.094.020 kB (906.764 available)
Paging file : 4.194.304 kB (730.992 available)
Virtual memory : 2.097.024 kB (1.955.832 available)

Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\jesilva\AppData\Roaming\PLSQL Developer\Preferences\jesilva\default.ini

Plug-Ins

Aliases
test

Homes
Dev6i_HOME (C:\oracle\dev6i)

DLLs
C:\oracle\dev6i\bin\oci.dll
C:\oracle\dev6i\bin\ORA803.DLL
C:\oracle\dev6i\bin\ORA804.DLL
C:\oracle\dev6i\bin\ora805.dll

TNS File
C:\oracle\dev6i\Net80\Admin\tnsnames.ora

Using
Home: Dev6i_HOME
DLL: C:\oracle\dev6i\bin\oci.dll
OCI: Version 8.0
Oracle Database 11g Release 11.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 178
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8ISO8859P1
NLS_CHARACTERSET: WE8MSWIN1252
NLS_NCHAR_CHARACTERSET: AL16UTF16

-- End info --

Can help me, please?

Thanks for all!

Regards,
Jean Carvalho Silva

 

[T-Gergely]

You could try a newer OCI client.
Isn't that CLOB an Xmltype actually?

 

[Jean Silva]

Hello,
Sorry for delay!
How I can find an newer OCI client? Sorry, but I don't idea.
Actually, is same a XMLTYPE.

Thanks and regards,
Jean Carvalho Silva