Toad World® Forums

Problems with XMLTYPE also in Toad 10.6.1.3


#1

Hello,

I updated from Toad 10.5 to 10.6 because I thought it would solve my problem. Alas.

I cannot edit an XMLTYPE field in the pop-up editor. Status bar displays following text “Read-only Windows style newlines (CR/LF)”. content of the xmltype field is displayed correct, but it is not editable.

We have an Oracle 10g DB and I’ve tried it with both the 10th and 11th clients without success.

My Laptop runs Windows 7 Enterprise and I’m a local admin. Maybe it’s a matter of some special settings.

I would very appreciate any kind of assistance to get this prob. solved.

Many thanks in advance and kind regards,

Andriy


#2

My issue still persists. I had to downgrade to Toad 9.5 where editing of XMLTYPE fields worked well. Attached the screenshot for comparison. snap1 and snap2 from Toad 10.6 and snap3 and snap4 from Toad 9.5. Any solution so far?
snap3.png


#3

My issue still persists. I had to downgrade to Toad 9.5 where editing of XMLTYPE fields worked well. Attached the screenshot for comparison. snap1 and snap2 from Toad 10.6 and snap3 and snap4 from Toad 9.5. Any solution so far?
snap1.png


#4

My issue still persists. I had to downgrade to Toad 9.5 where editing of XMLTYPE fields worked well. Attached the screenshot for comparison. snap1 and snap2 from Toad 10.6 and snap3 and snap4 from Toad 9.5. Any solution so far?
snap2.png


#5

My issue still persists. I had to downgrade to Toad 9.5 where editing of XMLTYPE fields worked well. Attached the screenshot for comparison. snap1 and snap2 from Toad 10.6 and snap3 and snap4 from Toad 9.5. Any solution so far?
snap4.png


#6

Editing of XMLTYPE is not supported in Toad 10.x. This is because Toad 10.x
supports Unicode, and the Oracle client, when in the Unicode mode, does not
support DML on XML data which is longer than 4000 characters. The only
workaround that I’m aware of is to store your XML in CLOB fields. If/when
this is fixed in the Oracle client, we can allow editing of XML in Toad (but
that doesn’t necessarily mean that we will re-introduce an XML editor)


#7

I am told that our new Toad for Eclipse plug-in does have this – so maybe
you can use toad for 90% of your work and the plugin for your xml data type
needs? I believe the plugin is free right now as an introduction type deal. But
don’t hold me to that ….


#8

thanks you for your answers!

@jdorlon: that is a real drawback for 10.6 not to support xmltype and dropping xml editor. Requirements engineers should have thought a bit longer about the consequences.

@bscalzo: eclipse plug-in is great. It can xmltype and even code completion for PL/SQL. I’m very impressed and will use it more often now.

Kind regards, Andriy


#9

We would have implemented it if we could. This isn’t about requirements,
it’s more about the errors from the Oracle client with Unicode and XML.


#10

You can also install a copy of v9.7 and use that for all of your XML work. Toad
lives happily next to other Toads…

Jeff