Search This Blog

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:

Using SQL Navigator, connect to Oracle DB as SYS user or a user that has SYSTEM privileges

From the menubar, select Tools->Server-Side Installation Wizard. Just click Next in the first screen.

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.

In this step, type a password for the SQLNAV user that the installation scripts will create. Click Next.

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.

Click the Install button, and go get a cup of coffee.

Connect to Oracle using the SQLNAV user and password you typed at step 5.

From menubar, select Team Coding -> Status. You should see that "Team Coding" is installed but not yet enabled, and all your permissions are checked.

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şı

Get link

Facebook

Twitter

Pinterest

Google+

Email

Other Apps

Comments

Popular posts from this blog

Attend the free webinar by the Oracle ACE Director Martin Widlake and learn how Oracle works under the hood. About the Webinar:
Despite the complexity and capability of the Oracle database, at it's heart there are a relatively small number of key activities and processes. If you understand them, you will get a lot more out of the database and advanced topics make a lot more sense. In this presentation I explain the key things the database does and how they work together. If you know what a SELECT statement is, you will understand this talk. And by the end of it, you will know some things that even many experienced developers and DBAs don't know. In this webinar, you will learn: The two ways Oracle reads data from disc and how it writes it back.That REDO is actually the most important part of the database. What happens when you COMMIT.Why Oracle data blocks are key to the buffer cache.What a "Consistent Get" really is.Why indexes are so powerful and what "balanced B…