Mostly Making oracle easy, mostly:
Search for:
ThatJeffSmith
In SQL Developer

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

1 Min Read

Got this question:

Answer: YES.

Make sure you select BOTH.

Then set your file type.

.SQL as requested

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

Yes, that.

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

Voila!
thatjeffsmith
Author

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

Related Posts

7 Comments

  1. Ali Reply

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

  2. Shaun Raven 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
      thatjeffsmith Post Author

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

      Can you export the spec by itself?

    • Shaun Raven

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

      Keep up the good work – I love this tool!

  3. TomasG Reply

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

Write A Comment