Here I'm SELECTing from a table with XMLTYPE column
and also length of the CLOB in KB.

1) I'm guessing that where it shows "Value Error" is because of the size...Can someone please confirm ?

2) What is the maximum size for the PLD to fetch a viewable CLOB ?

thanks


[Linked Image]

The maximum size for CLOB's is 2GB. I assume your XML documents are not that large.

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

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

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

hi Marco,
debug on as instructed.

From what I can tell - basically it is this error:

[Linked Image]

If you still need debug file, please let me know

Thanks

This may actually be an Oracle Server bug. Which Oracle Server version are you using?

[quote]Originally posted by Marco Kalter:
This may actually be an Oracle Server bug. Which Oracle Server version are you using? [/quote]Oracle 10gR2, (it's in my signature )

This may actually be caused by client/server character set conversion. Can you let me know if your client and server character set are indeed different? If so, can you also confirm that this problem goes away if you make the client character set the same as the server?

[quote]Originally posted by Marco Kalter:
This may actually be caused by client/server character set conversion. Can you let me know if your client and server character set are indeed different? If so, can you also confirm that this problem goes away if you make the client character set the same as the server? [/quote]Yes, agreed.

SQL> select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

VALUE
---------------
AL32UTF8


I'm using "instant client":

Using
Home:
DLL: C:\Program Files\oracle\instantclient\instantclient_10_2\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0
Character size: 4 byte(s)

I read it defaults to NLS_LANG-encoding US7ASCII

Do you know how to change the client character set ?

thanks

You can set character set of the NLS_LANG value in the Oracle registry (HKEY_LOCAL_MACHINE\Software\Oracle\...).

[quote]Originally posted by Marco Kalter:
You can set character set of the NLS_LANG value in the Oracle registry (HKEY_LOCAL_MACHINE\Software\Oracle\...). [/quote]I'm using "instant client" so I don't have Oracle info in the registry ....

This is still unresolved - I have tried setting NLS_LANG in Windows variable.

So Marco...have you ever been able to re-produce/resolve this issue on your end ?
Please try with 40MB CLOB, I hit this on that size.

thanks

I have not been able to reproduce this, but I will give it a try with a 40GB CLOB.