This content has been marked as final. Show 2 replies
There is no preference but it turns out you can manually edit one of the preferences.xml files to force PL/SQL types to use the SQL worksheet editor. For SQL Developer 3.2.20.09.87 that file is system3.2.20.09.87\o.sqldeveloper.22.214.171.124.87\preferences.xml and will be located (on Windows 7, for example) in directory C:\Users\<userid>\AppData\Roaming\SQL Developer
No guarantee this will work in future versions of the product, but for now you can add the following two xml blocks...
I researched this a while back after reading through some forum thread where someone claimed the PL/SQL file extensions got opened in the SQL editor in his environment, but without stating any specific release information. Possibly it worked for him then due to different product behavior (whether intentional or a bug), or perhaps even due to the technique described above.
For example, for .pls, add to <extensionToContentTypeMap ...> <Item> <Key>.pls</Key> <Value>TEXT</Value> </Item> and <userExtensionList> <Item> <docClassName>oracle.ide.db.model.SqlNode</docClassName> <userExtensions class="java.util.ArrayList"> <Item class="oracle.ide.config.DocumentExtensions$ExtInfo"> <extension>.pls</extension> <locked>false</locked> </Item> </userExtensions> </Item>
SQL Developer Team
Excellent. Thanks very much.
In a future release can the File Types Preferences be left unlocked for all file extensions so changing the preferences.xml file won't be necessary?