Mostly Making oracle easy, mostly:

In SQL Developer

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

April 27, 2017 1 Min Read

Got this question:

Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper

— Felipe Pereira (@FelipeR_Pereira) April 27, 2017

Then set your file type.

Now to confirm I’m really getting what I want.

SQL Developer will automatically open the file after it’s created.

Author thatjeffsmith

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Wisman 3 years ago Reply

can save package spec, body, synonym and grant at same time?
- thatjeffsmith Post Author 3 years ago
  
  I’m of till monday – till then, give it a try and see what you get. There are options to include dependents and grants for objects when doing Exports.
Ali 5 years ago Reply

Can we export multiple packages with their bodies with SQL Developer?
- thatjeffsmith Post Author 5 years ago
  
  I don’t think so, no.
Shaun Raven 5 years 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 years 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 years 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 years ago
  
  Cool, thanks Shaun!
TomasG 6 years ago Reply

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