Team Coding Installation for Oracle PL/SQL

If you write a lot of PL/SQL code, you must have thought of it at least once. It is probably when your teammate accidentally overwrote the same package that you saved seconds ago. Yes, I am talking about Team Coding.

If you are using SQL Navigator or TOAD for Oracle, you are just couple of clicks away to refine your PL/SQL development experience. In this article, I will outline the steps to install Team Coding to your Oracle Database to use with SQL Navigator. If you are using TOAD for Oracle, then I recommend you reading this article instead.

Now that you are still with me...

First things first, I haven't tried these installation steps on all possible versions of Oracle or SQL Navigator, but I believe they would work for most of them. In the office, we are using Oracle DB versions 10.2.0.1.0 and 10.2.0.4 and SQL Navigator version 5.1.

Here are the steps you need to follow:
  1. Using SQL Navigator, connect to Oracle DB as SYS user or a user that has SYSTEM privileges
  2. From the menubar, select Tools->Server-Side Installation Wizard. Just click Next in the first screen.
  3. If they are not already selected, select "Base SQLNAV Repository" , "Explain Plan Support" , "Team Coding Support" and click Next.
  4. In the next screen, you are asked for user credentials and TNS connection name. Once you provide the information and click connect, all available tablespaces will be filled to the tablespace combobox. You should choose the tablespace that holds the Database objects that are going to be versioned. In our environment, we use the "USERS" tablespace for development, so I picked "USERS" and clicked Next.
  5. In this step, type a password for the SQLNAV user that the installation scripts will create. Click Next.
  6. Do not change the defaults in the next three screens in the Wizard and just click Next to let installation create necessary roles to handle team coding configuration.
  7. Click the Install button, and go get a cup of coffee.
  8. Connect to Oracle using the SQLNAV user and password you typed at step 5.
  9. From menubar, select Team Coding -> Status. You should see that "Team Coding" is installed but not yet enabled, and all your permissions are checked.
  10. Click Settings, and select only "Enable Team Coding" and click OK. Now you should see that Team Coding is enabled.
This completes the installation of Team Coding.
To see Team Coding in action, open a PL/SQL package that is covered by Team Coding and attempt to modify it in the editor. It won't work. This is because you haven't checked out the package yet. Click the small icon in the toolbar  to check out the package. Now you should be able to edit it. When you done coding, simply check in the package, so that it becomes available to other developers for editing.

One thing that we realized after using Team Coding is that, it uses OS user to log you in, and it fails to protect packages if two separate developers use the same OS user, like "Administrator". So Team Coding works better if every developer logs in to his computer with a uniqure OS user.
This is obviously not a source code versioning system. It is merely a locking mechanism that prevents accidental overwrites. Later, I will post another tutorial to integrate Team Coding with CVS.
Serkan Kasapbaşı

Comments

Popular posts from this blog

PostgreSQL for Oracle Developers and DBA's