Re: Toad 11.5 and editing an XMLType

And what can I do in these situations? How can I add some XML content to a column that has an XMLType type? Is the only way to use INSERT statements?

T.

--- In [email protected], John Dorlon <john.dorlon@...> wrote:
>
> 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
> >
>




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/