RE: Re: Toad 11.5 and editing an XMLType

XMLTYPE columns are read only in Toad.  The pop up editor is read only because the OCI won't let us post XML changes back to the database.   An external editor isn't going to change that.  The article you read used a CLOB column that had XML data in it, not an XMLTYPE column.


From: [email protected] [mailto:[email protected]] On Behalf Of drbubo20
Sent: Thursday, September 06, 2012 6:00 AM
To: [email protected]
Subject: [toad] Re: Toad 11.5 and editing an XMLType



John,

I'm using XMLType column. Double click in the empty cell the pop-up editor is read-only because of OCI limitations, it's ok.
So I filled the XML Editor (MS XMLNote, and also the XMLMarker) in the Options|Executables.
But however I tried to save the content of the XML document in these Editors they didn't post the XML back to Toad (this new empty XML created like C:\Users\<user>\Appdata\Local\Temp\TOAxxxxx.tmp)

Tamas

--- In [email protected]<mailto:toad%40yahoogroups.com>, John Dorlon <john.dorlon@...<mailto:john.dorlon@...>> wrote:
>
> Assuming you are using a CLOB column to store your XML, since Toad 11.5 doesn't let you edit XMLTYPE due to OCI limitations in the Unicode-enabled mode....
>
> Can you just double-click in the empty CLOB column and paste your XML into the popup editor?
>
>
>
>
>
> From: [email protected]<mailto:toad%40yahoogroups.com> [mailto:[email protected]<mailto:toad%40yahoogroups.com>] On Behalf Of drbubo20
> Sent: Wednesday, September 05, 2012 9:04 AM
> To: [email protected]<mailto:toad%40yahoogroups.com>
> Subject: [toad] Toad 11.5 and editing an XMLType
>
>
>
> As reading the following article:
> Now when I invoke the editor by double-clicking on an XML cell, Toad sends the XML text directly to my editor of choice. When I'm done, I can send the data back to Toad to COMMIT my work. (http://www.toadworld.com/BLOGS/tabid/67/EntryId/466/Toad-for-Oracle-XML.aspx)
>
> Would you help me how can I post a newly created XML back to Toad?
>
> Tamas
>