Upon attempting to edit an XML document that is held within an "XMLTYPE" column on a table via said tables Data tab (i.e. by editing the column and invoking the XML Editor.) SQLDeveloper is failing to commit the change.
At the point of attempting to (/clicking) "Commit" to store the changes you are presented with the error below within the "View->Log->Messages" tab:
One error saving changes to table "SAPXMLIDOC"."SAP\_XML\_IDOC":
The "View->Log->Logging Page" tab has the following listed::
SEVERE 386 6 oracle.dbtools.raptor.controls.grid.EditableResultSetTableModel$DataTabGridUpdater java.io.BufferedInputStream.getInIfOpen(BufferedInputStream.java:159)
SEVERE 385 199443 oracle.dbtools.raptor.extendedtype.XMLExtendeType Illegal character in path at index 48: sqldev.xml:/C:/Users/<os_user_name>/AppData/Roaming/SQL Developer/tmp/XMLType5984587060161434573.xml
SEVERE 194 0 oracle.javatools.editor.MultiSelectionSupport$MultiSelection MultiSelection Not Disposed!
When you arrive back a the tables data grid the column value changes from "(XMLTYPE)" to the path of the locally edited XML file (e.g. sqldev.xml:/C:/Users/<os_user>/AppData/Roaming/SQL Developer/tmp/XMLType5195112422810329029.xml). It is apparent to myself using a MS Windows7 environment that the path is incorrect as it uses UNIX Path notation rather than windows path notation e.g. uses '/' char rather than '\' char potentially due to SQLDeveloper being developed on a Mac or Linux machine. This bug has existed on previous versions of SQLDev and I'd hoped would have been resolved by now.
