Mostly Making oracle easy, mostly:
Search for:
In SQL Developer

Why can’t I open .pkg files?

1 Min Read

Store your PL/SQL packages in files with .pkg extensions?

We CAN support that, but we don’t out of the box.

Open your preferences, go to File Extensions, and create a new entry for ‘pkg’ – and set the type of editor to PL/SQL.

pkg isn’t there on Day 1, you’ll need to add it

With this going, now when I do File – Open, and point to a file of that type, it’ll open in the PL/SQL Code Editor, and you’ll see all of the PL/SQL IDE features…like the compile/execute buttons and access to the Code Outline panel.

ta-da
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

4 Comments

  1. Torsten Kleiber Reply

    Simple test package header, file extension is pka here.
    In the menu are show the buttons run statement, run script, run in sqlcl, explain ans so on are shown.
    If I rename the file extension to pks, then run, then the buttons debug, compile and compile for debug on so on are shown instead.
    Configuration seem ok, as in status line is shown PL/SQL for pka.

    create or replace package pk_test is

    procedure pr_test (
    i_personal_nummer in number
    );

    end pk_test;
    /

  2. Torsten Kleiber Reply

    Hi!

    If I do the same on VS Code extension 26.1, then the toolbar is shown there for SQL Script instead for PL/SQL?

    Best regards
    Torsten

    • thatjeffsmith Post Author

      I would need to see what’s in your file to know why you’re seeing that.

      Make sure your file doesn’t look like a sqlplus script for starters.

Write A Comment