Running Beautifier on Command Line

[MartinF]

Is it possible to run the Beautifier for a specific file using command line without opening PLSQL Dev?

Ex:
something like
c:\program files\plsqldev\beautifier.exe c:\my_file.sql

Regards,

 

[Marco Kalter]

It can only executed from with PL/SQL Developer. You can create a command file and run it from the PL/SQL Developer command-line though. The cmmand file can look something like this:

beautify c:\scripts\employee.spc
beautify c:\scripts\employee.bdy
exit application

This will beautify the 2 source files and subsequently exit PL/SQL Developer. You can run the script from the Windows command-line like this:

plsqldev.exe userid=scott/tiger commandfile=c:\tmp\beaut.sql

 

[MartinF]

Cool, thank for the information Marco. This will solve my problem.

 

[MartinF]

Hi Marco,

Quick question about this. Is it possible to run PLSQL Developer to run my command file to beautify but without connecting to the database?

I removed the part with userid and when running the script it prompt me for username and password and if i press "Cancel" it don`t run my script to beautify. Is there an option like "nologging" to prevent PLSQ Developer to prompt for username and password?

Thank

 

[MartinF]

I just found the command nologon but when i specify it it don`t execute my command file is it a bug or a syntax error on my side. Here is my command

"C:\Program Files\PLSQL Developer\plsqldev.exe " nologon commandfile=c:\test\beaut.sql

 

[Marco Kalter]

I think you will need to logon (userid=user/pass@db instead of nologon).

 

[Paul Ljungqvist]

I think you will need to logon (userid=user/pass@db instead of nologon).

Does the software really need the db access for this operation?
Would it be possible to remove this restriction?

 

[Marco Kalter]

No, it is not necessary for this command specifically. The Command Window requires it in general though.

 

[Paul Ljungqvist]

Then I have this function as an enhancement request, if possible.

 

[Marco Kalter]

Okay, I have added this to the list of enhancement requests.

 

[braykov]

What is the planning about this request?