Apply the beautifier "in one" for all the objects in schema

[Imre]

Hi,
Is there any way to apply the beautifier "in one" for all the objects in schema (functions, procedures, packages, act...)? Thanks
Imre

 

[Marco Kalter]

You can create a command script to do this. See this topic for more information.

 

[Imre]

I tried run Beautifier by plsqldev userid=user/pass@db commandfile="c:\beautify.plsql" with

beautify.plsql as

SET BEAUTIFIERRULES 'C:\temp\newBeautifier.br'

BEAUTIFY test1.sql
BEAUTIFY test2.sql
/

where test1.sql , test2.sql are triggers in the Db , but in command window does errors:

Beautifying object: test1.sql
Failed: ORA-04080: trigger 'SQL' does not exist
Beautifying object: test2.sql
Failed: ORA-04080: trigger 'SQL' does not exist

If the triggers test1.sql , test2.sql are opened in window list of plsqldev ,all working properly.
Can you help me , with this ?

Thanx

Imre

 

[Marco Kalter]

You will need to add the complete path to the SQL file.

 

[Imre]

you are right , now works properly

thank you very much

Imre