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

April 27, 2017 1 Min Read

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 2 months ago Reply

can save package spec, body, synonym and grant at same time?
- thatjeffsmith Post Author 2 months 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 3 years ago Reply

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

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