search

mickeypearce / vscode-oracle-format

PL/SQL formatter (using SQLcl)
https://marketplace.visualstudio.com/items?itemName=mp.vscode-oracle-format
11 stars 4 forks source link

Command failed #25

Closed fernandoch777 closed 3 years ago

fernandoch777 commented 3 years ago

Hello, I keep on getting this error and I can't format any SQL files.

Command failed: "sql" /nolog @"c:\Users\fernando.vscode\extensions\mp.vscode-oracle-format-0.1.5\format.sql" '"sql"' is not recognized as an internal or external command, operable program or batch file.

Any hints for solving this?

Thanks

mickeypearce commented 3 years ago

You need sqlcl (sql.exe) to run the extension. Add the path to sql to global paths or use extension settings (oracle-format.sqlcl) to set a ful path to sql.exe.