Re: Oracle Application Standards

From: Marcus Hayes <mah_at_DIALix.oz.au>
Date: Tue, 20 Oct 92 10:00:59 GMT
Message-ID: <1992Oct20.100059.18323_at_DIALix.oz.au>


In <2uePsB3w165w_at_netlink.cts.com> tumidity_at_netlink.cts.com (Joel Garry) writes:

>stroup_at_grove.ops.lmsc.lockheed.com () writes:  

>>
>> I'd appreciate any information on how you control your production
>> applications.
>>

We have about 7 medium size projects (1-6 people each) active at any given time together with about 10 odd already completed projects We initially setup unix and oracle standards, created tools that enforced those standards ... like a script that generates a proto-type form with the standard delete, menu processing built in and creating central libraries of routines. Each team has their own library and then these are reviewed for inclusion in the master library.

The problem (challenge) of source control is handled by scripts to RCS, we tried SCCS but RCS was quicker. We have makefiles that control generation of a particular version.

Now for this to work we need ascii versions for each of the oracle products

*.rpt -> SQL*Report
*.rex -> SQL*ReportWriter
*.inp -> SQL*forms (2.0-3.0)
*.c,h -> Pro*C

Each user checks out a form/report etc. and when the changes have been made or development completed the form in entered into the RCS system.

Sorry, this is so terse ... the above has evolved over 4 years of trial and error ...
Please feel free to followup on any of the above points ive raised Received on Tue Oct 20 1992 - 11:00:59 CET

Original text of this message