Re: PLEASE HELP - Decision on PL/SQL tool

From: Lee Levy <levy.lee.ls_at_bhp.com.au>
Date: 1996/06/02
Message-ID: <4ot7uk$hs6_at_gossamer.itmel.bhp.com.au>#1/1

In article <31ADE941.5120_at_iafrica.com>, John Kotsaftis <jkotsaft_at_iafrica.com> says:
>
>I am currently working on a large data warehousing project. We are
>developing server side stored procedures in PL/SQL and need a good
>project management tool to do this. We need to check in/check out code
>and have version control.
>
>We installed Oracle Procedure Builder, and unfortunately it does not
>support server side PL/SQL stored procedure management. I am currently
>looking at Platinum SQL Coder.
>
>What is the best tool on the market to handle this kind of work? Is
>there an Oracle Product that supports this.

I had the same issue and also looked at SQLCoder. While it is a very nice product, I didnt go with it because it was too expensive for the 20 or so server side components we have. My problem is that I want to be able to stop people being able to bypass the config control.
I found that you really cant - you cant stop them jumping into Forms Designer and manipulating the code directly. Even if you took that away, you cant stop them jumping into SQL and manipulating the table that holds the server side code...

My eventual solution was a chekclist (ughh! more paperwork) that shows that they have cheked it out, they HAVE CONFIRMED THE CURRENT SOURCE VERSION AGAINST THAT ON THE DB and they have checked it back in.

HIH
Lee

---

  Lee Levy, ISSD Technical Dream Team, Del Code (34)   BHP Information Technology, ACN 006 476 213   PO Box 261, Warrawong, NSW 2502, Australia   PH: +61 42 75-5485 Fax: -5500 Tie: 8855-   Internet : levy.lee.ls_at_bhp.com.au

---

Opinions expressed are mostly my own, so give me some credit. Received on Sun Jun 02 1996 - 00:00:00 CEST