This discussion is archived
2 Replies Latest reply: Nov 15, 2012 5:20 AM by 900719 RSS

Standard Editor for file types!

900719 Newbie
Currently Being Moderated

In SQL Developer there is the possibility to assign certain file types to an specific editor. For example .pks/pkb to PL/SQL and PL/SQL starts the code editor. In newer Versions of the program, pks/pkb files are associated as SQL Scripts and these are opened in the standard worksheet. Is there any possibility to change this behaviour? There is no possibility to this in the UI, but there must be a config file or something.

Kind regards
  • 1. Re: Standard Editor for file types!
    Gary Graham Expert
    Currently Being Moderated
    Hi Jürgen,

    Is that really true? For which versions?

    Using 3.2.2, I tried opening some pks/pkb files and got the Code editor, not the Worksheet editor. Perhaps your user settings got corrupted somehow. You might try the usual technique of ...
    a. Export your connections and exit SQL Developer
    b. Delete (e.g., on Windows 7) the C:\Users\<username>\AppData\Roaming\SQL Developer\systemn.n.n.n.n folder for your version.
    c. Restart SQL Developer.
    It actually is possible to edit one of the preferences.xml files to force the pks and pkb extensions to use the Code editor (except I forced them to use the Worksheet editor in my test), but I believe the best (supported) approach is to reset the user settings first.

    SQL Developer Team
  • 2. Re: Standard Editor for file types!
    900719 Newbie
    Currently Being Moderated

    Well everithing works fine on my installation. We recognized the problem on a newly installed system with at a collegues workstation. The interesting thing is starting SQL Developer the next day, everything worked out fine. So for me the problem is solved, although I don't understand why these options are disabled in the UI.

    Kind regards,


  • Correct Answers - 10 points
  • Helpful Answers - 5 points