Add Package Spec & Body to VCS does not work

[Brian Baker]

I am using the VCS add-in for PLSQL Developer 6 along with Visual SourceSafe. I have the VCS preferences of Allow version control over DB objects and Add Spec and Body as a Single file enabled. However, only the spec or body (not both) is added.

If I go to the PLSQL Dev preferences > Oracle > Options and check Allow editing of databaase source it will work correctly. However, I do not want to have this option enabled as I want to ensure that the developers are only making changes to the database objects by checking the code out of VSS.

 

[Marco Kalter]

In that case you should not use the Allow version control over DB objects option, but enforce VCS from the file system. If you also disable the Allow compilation of read-only source files, you have ensured that only files that are checked out can be edited and compiled.

 

[Brian Baker]

To me it seems this is less productive. It is much easier to look at the object browser to find the item that needs to be edited rather than sorting through all the files in the file system.

Perhaps this is just a difference in workflow/methodology between the designers of the VCS plug-in and myself?

I have found a workaround that I can use. If I enable the Allow editing of database source, add the packages, and then disable the preference, I am then able to check out and edit the package as one unit. So I will use this method unless the VCS plug-in is updated in the future.