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 Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

7 Comments

  1. 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

      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!

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

Write A Comment