DBMS_Metadata / DDL - Extract spec and body to single file (SOLVED)

[HarrisDFO]

I did find other info in the forums on this, but nothing on how to do specifically what I need. I want to right-click the package in the objects explorer and extract the metadata (spec and body) into a single file.

Using v11.0.6.1176

UPDATE:

Scratch that request - just figured it out.

1. Edit or view spec&body (from the right-click menu)
2. Right-click in the editor window, choose 'Copy Window to...SQL Window'

Would be nice if I could do that in a single right-click step, though.

 

[Gustavo]

Hi!

Although the program window shows 2 tabs after step 1, you can save the file right away. Both tabs will be saved to a single file, so you won't need step 2.

Regards,
Gustavo