Package specification in SQL Navigator still shows as checked out with Subversion (SVN)
说明
When checking out a package body, a lock is also placed on corresponding package specification although only the body was requested. Within SQL Navigator repository only the body is checked out. When checking in the body, the lock on the package spec is not released.
If both body and specification are checked out, but only the body is checked in, both spec and body are committed in SVN, thus having the same commit note. The package spec in SQL Navigator still shows as checked out.
To replicate the issue -
- Install Tortoise SVN and create a repository - Create a sample Package Spec and Package body on the database - In SQL Navigator, go to Team Coding menu | Check out - Select only the Package Body
In the repository both Package and Package Body are seen.