Beautify all procedures.

[dbms_photoshop]

Hi!

Is there any way to create script for beautify all procedures for some schema?

Let's consider 2 cases.

1. With import/export.
2. Without import/export.

1. With import/export.
I can done it with this three steps
1) Export all procedures.
2) Generate script for beautify all of them.
Like this:

SELECT 'beautify ' || '&path' || object_name || '.prc'
  FROM user_objects
 WHERE object_type = 'PROCEDURE'

3) Import all procedues.

But I'cant automate import and export. Is it possible to do this?

2. Without import/export.
If i use "BEAUT[IFY] Object" it sucesfully works only if file opened in editor. Otherwise it done without any effect.
I can use commands: edit, beautify, but i need to compile and close edit window after beautify. Can I automate this process?

PS
Thanks for any response!

 

[Marco Kalter]

2. Without import/export.
If i use "BEAUT[IFY] Object" it sucesfully works only if file opened in editor. Otherwise it done without any effect.
I can use commands: edit, beautify, but i need to compile and close edit window after beautify. Can I automate this process?

This seems like a bug. We'll fix it.