I have a test table containing a number column and an XMLTYPE column which I use to store XML data in for development purposes.
If I store a XML record in a file and click on the XMLTYPE column and use the "load" functionality the XML gets stored in the table and I can query it.
If I click on the column and use the 'Editor" option and paste the XML in and then close the editor window I'm prompted with:
C:\Users\xxxxx\AppData\Roaming\SQL Developer\tmp\XMLType6982377551135927678.xml has been modified. Save changes?
I click on Yes and I get this in the message log:
Ignoring C:\Users\xxxxx\AppData\Roaming\SQL Developer\tmp\XMLType6982377551135927678.xml; not on source path
[13:40:20] Compilation complete: 0 errors, 1 warnings.
Build after save finished
and the data is not saved in the database.
The file is present in the path as shown.
This method use to work fine with 4.0.x