My setup is I have Oracle 184.108.40.206.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 220.127.116.11.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 18.104.22.168 patchset release. The 22.214.171.124 patchset release for Solaris is available for download from the Patches option on MetaLink Home.