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

thatjeffsmith SQL Developer 7 Comments

Tell Others About This Story:

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!

Related Posts

Tell Others About This Story:

Comments 7

    1. thatjeffsmith Post
      Author
  1. 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?

    1. thatjeffsmith Post
      Author
      1. thatjeffsmith Post
        Author

Leave a Reply

Your email address will not be published. Required fields are marked *