SQL Navigator for Oracle 7.4 - Installation Notes

Check in and Check out

The check-in and check-out of objects that are controlled in Team Coding or the VCS can be done in different ways in SQL Navigator.

Check in/check out individual objects

The Check In and Check Out buttons in Team Coding Manager can be used for both database objects and files.

When you check out an object or file, it locks that item in the database. The item remains locked until you check in your changes through Team Coding. You must check out an object before you can compile it.

If a VCS is being used, there are two parts to a checkout

1. Check out the source from the VCS.
2. Create a check-out transaction for the object in Team Coding. This is what determines the state of the object in DB Navigator or Team Coding Manager.

If a VCS is not being used with Team Coding, only step 2 from the preceding actions occurs. Team Coding does nothing with your source code in this case.

To check individual items in and out

1. Open the script or select the object in the .
2. Click to check out an object or click to check in an object.

You can also check in or check out an object by right-clicking it in DB Navigator or Team Projects browser, and then selecting the desired command.

Check in all items

To check in all objects at the same time, you can:

• Click on the Team Coding Manager toolbar.
• Select Team Coding | Check-in all to open a dialog where you can select objects individually from a list.

If a VCS is being used, there are two parts to a checkin:

1. Check in the source to the VCS.
2. Create a check-in transaction for the object in Team Coding. This is what determines the state of the object in DB Navigator or Team Coding Manager.

If a VCS is not being used with Team Coding, only step 2 from the preceding actions occurs. Team Coding does nothing with your source code in this case.

Automatic Check In and Check Out

You can have SQL Navigator automatically check in an item when you open it and check out an item when you close it. You can also have SQL Navigator prompt you to enter a comment. For more information, see Configure Team Coding.

Undo a checkout

To cancel the check out and reverse any changes, click on the Team Coding Manager Toolbar. Alternatively, you can right-click the object then select Undo check-out.