My setup is I have Oracle 126.96.36.199.0 Server running on Win2K Server. I have a UTF8 database which I'm trying to connect to from SQL*Plus on Solaris 8 / Oracle 188.8.131.52.0 Client (uid/pwd@sid). I am querying a table with CLOB values using the following SQL:
SELECT parameterid, name, label, description, value, isretired, editedby, timeedited FROM kc_parameter WHERE name = 'ServiceLevel';
NLS_LANG on both machines is set to UTF8.
I can query tables that do not contain CLOB columns fine.
It would appear you are encountering bug 1130746 where this error can be signalled when selecting a CLOB column from an UTF8 database in certain client server configurations, such as NT<->Solaris. The bug is fixed in Oracle9i and included in the 184.108.40.206 patchset release. The 220.127.116.11 patchset release for Solaris is available for download from the Patches option on MetaLink Home.