How to Save a Package and Package Body to a .SQL File

7 Comments

1. 

   Ali 5 months ago Reply

   Can we export multiple packages with their bodies with SQL Developer?

   • 

     thatjeffsmith Post Author 5 months ago

     I don’t think so, no.

2. 

   Shaun Raven 5 months ago Reply

   I’ve got an interesting problem with this. If I try and export, I only get the package body, not the spec. Also, if I try TomasG’s suggestion, I get a zero length file. Any ideas why this might occur?

   • 

     thatjeffsmith Post Author 5 months ago

     Did you select both in the tree? I just tried and it worked for me.

     Can you export the spec by itself?

   • 

     Shaun Raven 5 months ago

     Ah – selecting both worked for me to. That’s good enough.

     Keep up the good work – I love this tool!

   • 

     thatjeffsmith Post Author 5 months ago

     Cool, thanks Shaun!

3. 

   TomasG 2 years ago Reply

   Or simply choosing “Save Package Spec and Body…” in context menu