Forum Stats

  • 3,876,186 Users
  • 2,267,078 Discussions


VSCODE: Edit files with .pls or .plb extension and compile them into the DB

HELLO Everybody,

Is it possible to edit .pls or .plb files and compile them directly from vscode into the DB?

It seems that only .SQL or .PLS extensions are supported.

Thanks a lot for your reply



  • Christian.Shay -Oracle
    Christian.Shay -Oracle Posts: 2,248 Employee
    edited Jul 15, 2021 8:02PM

    Hi, and welcome to the forums!😀

    Did you associate the file types with our extension? You can do that by clicking on the language mode at the bottom in the status bar and temporarily associate the file with our extension. Or you can permanently associate the file extension with our tools like so:

    Settings > type "files:associations" in the Search Settings field > click Add Item > set Item. to "*.pls" and Value to "oraclesql" and click OK.

  • User_VID0T
    User_VID0T Member Posts: 1 Green Ribbon

    Christian's guidance about adding permanent file associations is not quite right. When adding a file association, the pattern should be "*.pls" instead of just the extension. In case you are skeptical of some random person on the Internet, this text comes directly from VS Code Settings editor:

    Configure file associations to languages (e.g. "*.extension": "html"). These have precedence over the default associations of the languages installed.

  • Thank you very much for the correction. I have updated my post to fix the error.