Drag and Drop of File from Directory with Special Character Shows Blank File in Editor Tab
(Doc ID 2085611.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle SQL Developer - Version 4.1 and later
Oracle JDeveloper - Version 18.104.22.168.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
SQL Developer does not correctly open editor tabs if files are dragged-and-dropped into the tool from directory structures that use special characters, such as pound ("#"). A new tab is opened for the newly added file, but the editor shows no file contents. The tab for the newly added file only shows the text of the directory up to the special character. It appears the tool as far as the special character, and therefore perceives there are no file contents to display.
For example, given the following directory file structure:
1) File -> Open myfile1.xml from C:\TST\. An editor tab is opened and the file contents are displayed.
2) Drag and drop myfile2.xml from C:\TST\ into the editor pane. A new tab is opened and the file contents of the newly added file are displayed.
3) File -> Open myfile3.xml from C:\TST#\. An editor tab is opened and file contents are displayed, even though the file was opened from within a directory containing a special character.
4) Drag and drop myfile4.xml from C:\TST#\ into the editor pane. A new tab is opened, but no file contents are displayed. The name of the new editor tab is "TST" and not the file name. SQL Developer is only reading as far as the # in the directory name.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document