Mostly Making oracle easy, mostly:
Search for:
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!
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

9 Comments

    • thatjeffsmith Post Author

      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.

  2. Ali Reply

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

  3. 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 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!

  4. TomasG Reply

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

Write A Comment