# XML display issue **URL:** \ **Category:** Toad for Oracle & DevOps Toolkit\ **Created:** [March 23, 2010, 9:10am UTC](https://forums.toadworld.com/t/xml-display-issue/9372 "2010-03-23T09:10:51Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\ **Post date:** [March 23, 2010, 9:10am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/1 "2010-03-23T09:10:51Z")
I’m running Toad version 10.1.1.8, and have an issue with running the following in the editor (using a 11.1.0.6.0 oracle database): CREATE TABLE test\_table1 (xmltext XMLTYPE) XMLTYPE COLUMN xmltext STORE AS CLOB; INSERT INTO test\_table1 VALUES (xmltype (‘hello’)); COMMIT; SELECT \* FROM test\_table1; CREATE TABLE test\_table2 (xmltext XMLTYPE) XMLTYPE COLUMN xmltext STORE AS BINARY XML; INSERT INTO test\_table2 VALUES (xmltype (‘hello’)); COMMIT; SELECT \* FROM test\_table2; All works fine, except the last select. It throws the error: ora-21500: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] Only difference is the storage type of the xml. This works fine in Toad 9.7, and sql developer, sql\*plus, etc. Any ideas what may cause this? Thanks. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 23, 2010, 9:10am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/2 "2010-03-23T09:10:51Z")
Toad supports unicode starting with Toad 10. One of the changes we had to make is to use the Unicode-enabled OCI methods. Unfortunately, the OCI has a few bugs with Unicode. This is one of them. You can work around it like this: SELECT T.XMLTEXT.GetClobVal() as XMLTEXT FROM TEST\_TABLE2 T This workaround will be automatic in Toad 10.5’s schema browser. You’ll still have to code it manually in the editor though. John ---
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\ **Post date:** [March 23, 2010, 9:29am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/3 "2010-03-23T09:29:32Z")
One of my coworkers can no longer debug his packages and procedures after upgrade to oracle 10.2.0.4.3 TOAD help says that the minimal requirement to debug is: You must have the DEBUG CONNECT SESSION privilege, or Oracle will not let you use DBMS\_DEBUG. I am not aware of any privilege or role named DEBUG. Please advise. ---
**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\ **Post date:** [March 23, 2010, 9:36am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/4 "2010-03-23T09:36:54Z")
![image001.png](https://global.discourse-cdn.com/quest/original/2X/6/6439d8f02f9b383dd1281e79c94869a80a22dc02.png) ---
**Author:** ![NormTeamT](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/normteamt/32/53_2.png) [@NormTeamT](https://forums.toadworld.com/u/NormTeamT)\ **Post date:** [March 23, 2010, 9:47am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/5 "2010-03-23T09:47:49Z")
Hi George, > > I am not aware of any privilege or role named DEBUG. Please advise. you need to : ``` GRANT DEBUG CONNECT SESSION TO your_user; ``` The privilege is "debug connect session" Cheers, Norm. [TeamT] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at [www.environment-agency.gov.uk](http://www.environment-agency.gov.uk) ---
**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\ **Post date:** [March 23, 2010, 10:05am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/6 "2010-03-23T10:05:33Z")
Thanks. But running that query, even though there’s now no error, just produces a blank (null) cell. The query returns data ok through the other clients I’ve tried. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 23, 2010, 10:05am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/7 "2010-03-23T10:05:33Z")
When I run that query, I see a cell with in it. If I double-click it, then I see the data. If I go to Options -\> Data Grids -\> Data, and check “Preview CLOB and LONG data”, then I see the first 20 characters or so followed by ’.…’ and then I can again double-click to see the rest. ---
**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\ **Post date:** [March 23, 2010, 10:29am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/8 "2010-03-23T10:29:35Z")
I had that option checked. When unchecked I see the (HUGECLOB) and I can double click and see the data in the popup editor. But when it’s checked then it’s a null value. However, if I also check the Deferred LOB read box then it displays as I would expect. Any ideas what this option is doing? Thanks. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 23, 2010, 10:29am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/9 "2010-03-23T10:29:35Z")
‘Deferred Lob Read’ is supposed to delay fetches of LOB values until you scroll to them in the grid. If there is more than a screen full of data, it will reduce initial fetch time. But it should not cause what you are seeing. What Oracle client version do you have? I am not sure offhand if this is a factor, but it is worth checking. I am using an 11g client, and I’m not seeing null regardless of the option settings. ---
**Author:** ![geigerweb](https://avatars.discourse-cdn.com/v4/letter/g/7feea3/32.png) [@geigerweb](https://forums.toadworld.com/u/geigerweb)\ **Post date:** [March 23, 2010, 10:53am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/10 "2010-03-23T10:53:11Z")
Thanks. It’s the latest 11g database I have installed on my laptop, not just the client. 11.1.0.6.0 for windows. ---
**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\ **Post date:** [March 23, 2010, 10:53am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/11 "2010-03-23T10:53:11Z")
Actually Oracle has a 11.1.0.7 patch – so you’re close to latest J ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [March 23, 2010, 10:53am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/12 "2010-03-23T10:53:11Z")
Mine is actually 11.1.0.1, so I don’t think this is related to client version. ---
**Author:** ![Marcy](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@Marcy](https://forums.toadworld.com/u/Marcy)\ **Post date:** [May 17, 2010, 12:00am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/13 "2010-05-17T00:00:43Z")
Toad Version 10.5 Hi, is this the same explanation as to why I am getting (HUGECLOB) displayed in my xmltype column, when I try to view the contents of my table via the Schema Browser ? If I try to click on HUGECLOB, it displays my xml in one line only. If i do a select \* from , the data grid displays my xmltype data in a formatted manner and easily readable. I’ve tried the options the others mentioned in this thread, which doesn’t really fix how its displayed in the schema browser… ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [May 17, 2010, 8:28am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/14 "2010-05-17T08:28:59Z")
Some Oracle clients would crash when you look at XML Data. So I made a change in the schema browser to always return XML as CLOBS by changing the query using the GetClobVal function. Later, we learned that 11g clients do not have the problem. So I made a change in the 10.5 patch (and current beta) to stop using GetClobVal if you have an 11g client. Short version – get the latest Toad patch and this will go away. ---
**Author:** ![Marcy](https://avatars.discourse-cdn.com/v4/letter/m/ec9cab/32.png) [@Marcy](https://forums.toadworld.com/u/Marcy)\ **Post date:** [May 20, 2010, 10:16pm UTC](https://forums.toadworld.com/t/xml-display-issue/9372/15 "2010-05-20T22:16:08Z")
Thanks, just got the patch the other day. It worked. ---
**Author:** ![JayZeeTio](https://avatars.discourse-cdn.com/v4/letter/j/278dde/32.png) [@JayZeeTio](https://forums.toadworld.com/u/JayZeeTio)\ **Post date:** [July 6, 2010, 3:45am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/16 "2010-07-06T03:45:42Z")
I have not been able to get this working for a couple of months and have had to revert back to TOAD 9.7.2. I have installed TOAD 10.5 and I have Oracle 11.1.0.6 client on my desktop. I still get the OCI error. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 6, 2010, 8:42am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/17 "2010-07-06T08:42:12Z")
I reread the thread, and tried it again. I am able to reproduce the problem even with the latest 10.5 patch and an 11g client. I should have been more thorough before I replied the first time. Sorry about that. I also tried it with the beta – it gets a little better there – I only get an error one time in the beta, and after that, it works! I’m not sure what is going on, but I think the problem is coming from our 3rd party Oracle access components. I will send your test case to them and see what happens. ---
**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\ **Post date:** [July 7, 2010, 11:49am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/18 "2010-07-07T11:49:45Z")
I opened a case with our 3rd party component developer, they are saying that it is a bug in the OCI, which happens for XMLTYPEs with binary storage and OCI in the Unicode mode (in 9.7 and prior, there was no Unicode). So I’m afraid all I can tell you is what you already know – you can work around it in 10.x by not using the binary storage options for XMLTYPE. ---
**Author:** ![erdnando](https://avatars.discourse-cdn.com/v4/letter/e/d26b3c/32.png) [@erdnando](https://forums.toadworld.com/u/erdnando)\ **Post date:** [May 11, 2013, 1:52am UTC](https://forums.toadworld.com/t/xml-display-issue/9372/19 "2013-05-11T01:52:07Z")
SOLVED: Yo tambien tuve ese problema y despues de revisar el tema y varios foros encontre que algunas tblas en las cuales tenia campos xmltype, sucedia el error y en otras no. revise y detecte que las tablas que no habia error tenian la sig declarción: ALTER TABLE WF\_USUARIO ADD (COBERTURA XMLTYPE); y las que no tenian error: ALTER TABLE WF\_USUARIO ADD (COBERTURA **SYS**.XMLTYPE); entonces, recree el campo con la definicion completa a sys.xmltype y toad funciono correctamente espero les sirva saludos