PL/SQL Syntax highlighting in Visual Studio 2015

Question

Does anyone know how to get Visual Studio 2015 to recognize that a file is PL/SQL and highlight keywords etc?

I have installed the Oracle extension which makes the PL/SQL language show up under Text Editor Languages. However I cannot find a way to link that language for syntax highlighting to a file extension.

I have tried Text Editor-->File Extension to add that way but that allows you to select an editor rather than a language, what I am looking for is Simple Text editor with PL/SQL Syntax highlighting in Visual Studio.

Answer 1

I was able to get some basic syntax highlighting, simply for colors on keywords, not using it for compilation.

Tools => Options => Text Editor => File Extension

1. Extension: pkb (this is our package body file extension)
2. Set the editor to Microsoft SQL Server Data Tools, T-SQL Editor...I assume you would need to install SSDT as part of the VS install.
3. Click Apply to add it to the list.
4. Repeat for each PLSQL file extension

Initially this didn't work, so I changed it to the editor: Microsoft SQL Server Data Tools, T-SQL Editor (with encoding) then changed it back and I got the colors.