Stand alone beautifier

[Volker]

Enhancement request (I think): is it possible to use the plsql beautifier as a standalone program or with special command line options?

thanks,
Volker

 

[Marco Kalter]

Yes. You can use the "BEAUTIFY FILE | OBJECT" command in a Command Script. This script can be executed through PL/SQL Developer from the Windows Command Line.

 

[Volker]

I tried

plsqldev.exe nologon commandfile="c:\beautify.plsql" test.sql

with beautify.plsql as

SET BEAUTIFIERRULES "C:\temp\PLSQLLayout.br"
BEAUTIFY %1

PLSQLDeveloper starts an loads the file test.sql. But the file will not beautified and saved; PLSQLDeveloper is open and waits.

 

[Marco Kalter]

You cannot pass parameters to the command script. A script like this would work:

SET BEAUTIFIERRULES "C:\temp\PLSQLLayout.br"
BEAUTIFY test.sql
EXIT APPLICATION

 

[Volker]

Starting plsqldev with nologon was an other mistake.
with userid=... the script runs perfectly.

thx