|
CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
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]
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
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.
Marco Kalter Allround Automations
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
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
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
This may actually be an Oracle Server bug. Which Oracle Server version are you using?
Marco Kalter Allround Automations
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
[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 )
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
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?
Marco Kalter Allround Automations
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
[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
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Aug 1999
Posts: 22,200
Member
|
Member
Joined: Aug 1999
Posts: 22,200 |
You can set character set of the NLS_LANG value in the Oracle registry (HKEY_LOCAL_MACHINE\Software\Oracle\...).
Marco Kalter Allround Automations
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
[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 ....
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
Re: CLOB Column Displayed as "Value Error"
|
Joined: Apr 2004
Posts: 203 NYC, USA
Member
|
OP
Member
Joined: Apr 2004
Posts: 203 NYC, USA |
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
Last edited by RobertK; 12/15/08 11:52 PM.
PlSQLDev Version 8.0.4 Oracle 11gR2
|
|
|
|
|
|