Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL Versioning

704221Jun 4 2009 — edited Jun 8 2009
We've recently started working on some legacy PL/SQL packages on a database system and finally want to apply proper version control to them. SQLDeveloper seems like the most appropriate solution, but before I start exporting and versioning all willy-nilly, I thought that I'd better ask some questions beforehand.

We've got all the initial packages in the development database, and from reading the documentation it looks like I'll have to export and import the specs and bodies of the packages to a DDL file, which I put under version control (Subversion in our case). Now this gets repeated a lot, so is there any way to automate some of those steps and/or work with the packages a bit more directly?

Maybe I'm just missing some options or a plugin. Ideally you'd make some configuration options that would do the "Save Package Spec and Body" in the background and would allow the Versioning options to treat packages like files...

If anyone has some good Best Practices about working with PL/SQL packages under version control, I'd be very interested in hearing them.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2009
Added on Jun 4 2009
3 comments
2,097 views